Hello all,

I need some help with something similar to a vlookup.
The books I am searching in are different all the time.
I would like to identify my value in the main workbook
and look in the other books to find a duplicate. When I
find the value I need to return the value of a cell three
columns over.

I can identify the workbook and worksheet, but I cannot
gety it to work in a vlookup formula. My "junior
programer" solution would be to go to the column in the
worksheet and go down one row at a time (loop) until I
found the value. I know there is a more efficient way.

thanks in advance.