Hi,
Open up two workbooks - Book1 and Book2. Add the number 3
to cell A1 in Book1. Add the following formula to cell B1
in book1 (note the "[Book2]Sheet1" reference):
=VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$5,2,FALSE)
Add the numbers 1,2,3,4, and 5 in cells A1:A5 in Book2.
Add the numbers 3,6,4,7, and 3 in cells B1:B5 in Book2.
The vertical lookup formula should return 4.
Also, in Excel's online help, look up "link formulas" and
then "create a formula to calculate data from another
worksheet of workbook".
John Mansfield
pdbook.com
-----Original Message-----
This is probably a very elementary question, but if you don't know, well you
just don't know.
How do I create a lookup function that is looking up a value in another
workbook.
Thanks in advance.
.
