Thanks Johnwm and CinciMace. I am working on the macro based on your suggestions and will let you know if it works successfully.
I really appereciate your help!
Thanks,
Chirag
Hi,
I am completely new to VB and am trying to write a macro in it. I am trying to create a VLOOKUP function that would search more efficiently than the one excel provides.
For example if I had a table below:
Database 1 Database 2
General Motors General Motors...