Searching and Retrieving a Value from another excel sheet! Please help?

whats your formula look like?

This formula is in Book2 B1

Book1 has the data


=VLOOKUP(A1,[Book1]frty!$A$3:$B$10,2,FALSE)

the books need two be opened for these to work if you want book1 closed then we may have to go to VBA

Originally Posted by stan123

Hey Dave,

thanks allot for your reply i really appreciate it.

I wanted to ask, since I cannot have all the 12 excel files open...what function can I use to automatically import all data in another excel sheet workbook to the main excel file which is open. SO i can run the VLOOKUP routine without opening up all the excel files.

Hi,
Make sure all the xl files are in the same directory(folder)

Then use the code from this Post
http://www.excelforum.com/showthread.php?t=589590

You will have to change the ranges and also the the folder name and then play with the workbook

Originally Posted by stan123

Hi Dave,

sorry to bother you again! Just wanted to ask a quick question

I want VLOOKUP to search column B for a specific value. When it hits that I want it to go to column O on the same row to retrieve the value I want. How would I go about this?

cheers dave.

Hi Stan,

=VLOOKUP(A1,[Book1]frty!$A$3:$B$10,2,FALSE)

=VLOOKUP(what to look up,range of data,column number you want to display,false real result)

in your case your range would be

=VLOOKUP(A1,B5:O12,14,FALSE)

14 is the key for this example, it is the 14th column where the data you want is....

heres a small example of vlookup




http://www.excelforum.com/attachment...1&d=1162047932