Vlookup
 

can i do a VLOOKUP from a different workbook ? if so , how to do it?

tks in advance..


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=465822

Fairly easily:

I assume the cell that is being used as the reference cell is on the
open sheet and that the vlookup table is on another workbook which
should also be open:

=vlookup(a1,{at this point use the mouse to point at the range of cells
in the other workbook and drag over your chosen range, press the comma
key and enter any number for now over 1} close the formula with a )

You will need to edit the formula to ensure that you are returning the
value from the required column, to do this you will need to change the
last digit to refer to the required column

Hope this helps

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=465822

Hi cjjoo

You can do a vlookup into another workbook provided it is open when you
perform this function. If you open a file which contains a vlookup
formula from another workbook it will prompt u to update links ..... if
u select to do so, you need to open that file... else it will show
error. To retain the existing values select do not update..

as far as the 2nd question goes.... it is same as any regular vlookup
formula... you can get many links on this group on how to write one.
Just lookup for vlookup.

Karthik Bhat