Lookup Based on Criteria

Hi,
I am looking For VBA to lookup on user specified columns.(i.e User should able to select a column to lookup on another sheet and again user has to select on which column value has to be looked up). I am attaching the sample book. Please have a look and help me out in this issue

Regards
Maruthi

Hi

Why you need VBA ?

Try either VLOOKUP or INDEX/MATCH functions

Please find attached.

HTH

Hi,
Thanks for earlier reply. I used to do Vlookup earlier.I have lot of files to do per do. I cannot do manually. So i am looking for a VBA code to automate by giving column names by input box.Can you please provide the code
Regards,
Maruthi