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