Shouldn't the headings in both the first and second sheets be the same?
Should they not be the same as the headings in the "Result" sheet?:-
Dealer ID Dealer Name Brand Status Product
It would be best if you uploaded a sample of your work book showing your inputs and expected results so that we can understand exactly what it is that you are trying to do.
You can upload a sample of your work book using a free file sharing site such as DropBox, ge.tt or Speedyshare. Someone should then be able to help you.