linking workbooks

P

Pennywis1

I would like to enter an item number in column A of the destination workbook,
yet have additional information pertaining to that item number pull from a
source workbook to the destination workbook. Any idea how I can do this?
 
P

Pete_UK

You can use VLOOKUP to do this. Check it out in Help, or re-post here
with a few more details of what you want to do.

Hope this helps.

Pete
 
J

Jop Duyvendak

Not sure how complex or simple the structure of your source workbook is, but
you can open both workbooks, enter in Column B of the destination workbook
the formula =VLOOKUP(A1;range;columnnr), where range is the range in the
sourcebook. To enter this, just enter the formula =VLOOKUP(A1; and then
move your mouse to the table in the sourcebook and select the table. Hit ;
and then enter the columnnumber where excel finds the info to be pulled. Note
that the leftmost column needs to be the column where Excel finds the value
that you have in column A of the destination sheet. Note thast there are
conditions to the structure of the lookup-table. If the structure is more
complex, then I suggest you consider the DGET function....

Shout if this doesn't do it....
 
Top