Using multiple Lookup Functions

[Gaura215]

Respected Excel Gurus

I spent nearly 2 hours daily on updating a report from a dump, which I download from a website. I am wonderin if this can be automated using some formulaes or Macro. Please help me out.

I can share the 2 spreadsheets which I need to compare. Please advice, if someone can help me with this. Its difficult to explain it in words without sharing the spreadsheets. So I will share the spreadsheet with whatever explanation I can give.

Help please

 

[Gaura215]

BlueHornet

Your second one works perfectly fine for me. Thanks a lot.

Peter, thanks to you too to make me learn important tips to post my problems over here.

Thanks guys

 

[BlueHornet]

You're welcome. I'm glad it worked for you.