Help with Vlookup to several workbooks
 

Hi Tom, the Vlookup that you helped me with works really great and thank
you. I have now a new request in that i have column "A" with the part
numbers in and column "I" with the prices in and i have six different
quotes. Column "I" has prices which are contained in all six quotes and
i need to do vlookup's to confirm the prices. Do you suggest that i
first open workbook A do a lookup then close and open workbook B then
lookup etc.. In other words i would have the same routine six times,
just looking in different workbooks..... Also must the workbooks be open
to do the lookup ?

thanks in advance.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Help with Vlookup to several workbooks
 

Looks like Bob gave you an answer to a later posting.

--
Regards,
Tom Ogilvy


"Les Stout" wrote in message
...
Hi Tom, the Vlookup that you helped me with works really great and thank
you. I have now a new request in that i have column "A" with the part
numbers in and column "I" with the prices in and i have six different
quotes. Column "I" has prices which are contained in all six quotes and
i need to do vlookup's to confirm the prices. Do you suggest that i
first open workbook A do a lookup then close and open workbook B then
lookup etc.. In other words i would have the same routine six times,
just looking in different workbooks..... Also must the workbooks be open
to do the lookup ?

thanks in advance.

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Help with Vlookup to several workbooks
 

Hi Tom, he answerd my last question but not the first part.


Thanks in advance

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

Help with Vlookup to several workbooks
 

I only see one question if the answer is the formula he gave you.

--
Regards,
Tom Ogilvy


"Les Stout" wrote in message
...
Hi Tom, he answerd my last question but not the first part.


Thanks in advance

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***