Scan Market components updates using vba/Vlook-up

Hi All,

Have a good day.After a long long time i'm here came for help from experts.Based on this forum's guide now i can able to tackle many things.Thanks for all the experts. The below is my new thread.

I have did some alignment and vlook up,finally i have designed this workbook attached <Coach Auction 04082015_test1.xls>.
BUt i need to make some sync up's to get the expected data forms.I have explained all the things in the attached word document with the snap shot(For better understanding).

Macrospec.ppt: I made a ppt which more or less tries to explain what needs to be done. Hopefully it is logically correct. My programming skills are quite basic, so there is no guarantee it is ok.
Coach Auction 04082015_blank2.XLS: This sample should be the blank worksheet
Coach Auction 04082015_test1.XLS: This sample should be the output.


The SCANMARKET (records marked in green as examples) / VENDORS tabs will the standard input

Thanks in advance