Hi, I need some help with importing information from 2 different workbooks
into a third one. The problem that I have is the following: the reference
points from where the information needs to be pulled from are not the same
cells every day but information in column A that point to the information in
column B in the same row that need to be pulled into the 3rd workbook. In
Detail: in ressource workbook 1 I have the order # in column A and shipping
information for each order # in column B. Those shipping information for each
order # need to be pulled into the 3rd workbook in which the order # of
workbook 1 are part of a bigger list; and this list of order # is changing
every day. So I need a formular for importing data which says €œif you find
the same value in column A in workbook 1 and workbook 3, than pull
information from workbook 1, column B same row into workbook 3 column G same
row€� €“ something like that.
Who can help me with that? Every imput is very much appreciated.

You need the VLOOKUP( ) function. This enables you to search for a
value in a table, and if found then you can return the value from a
corresponding column. I'm not sure where your second workbook comes
into it, though, from your description - perhaps if you could give some
further details of what you have...

Hope this helps.

Pete

Hi Pete,

thank you very much for your response and your offer to help. I haven't
worked with this level of Excel functions yet and I'm not a native speaker
(I'm German actually stranded in San Francisco) so the following description
might miss some elegance, but hopefully I can describe what we need accurate
enough.

The goal is to build a report which pulls daily information about order
status from 2 different sources (Excel workbooks) into a 3rd workbook. All 3
workbooks contain a column with the order numbers and additional columns with
further information about the orders, one row per order. Source workbook 1
and 2 have each one column next to the order number column with an
information that should be pulled automatically into two different columns in
workbook 3. Workbook 3 contains more order numbers though then workbook 1 and
2, so when the information from workbook 1 and 2 are pulled some cells in
those columns in workbook 3 would be filled, some would be empty. The order
numbers in all 3 workbooks are changing daily. Please let me know if this
description is detailed enough to give you a picture of what I try to
accomplish. Thank you very much, Susanne.


"Susanneec" wrote:

Hi, I need some help with importing information from 2 different workbooks
into a third one. The problem that I have is the following: the reference
points from where the information needs to be pulled from are not the same
cells every day but information in column A that point to the information in
column B in the same row that need to be pulled into the 3rd workbook. In
Detail: in ressource workbook 1 I have the order # in column A and shipping
information for each order # in column B. Those shipping information for each
order # need to be pulled into the 3rd workbook in which the order # of
workbook 1 are part of a bigger list; and this list of order # is changing
every day. So I need a formular for importing data which says €œif you find
the same value in column A in workbook 1 and workbook 3, than pull
information from workbook 1, column B same row into workbook 3 column G same
row€� €“ something like that.
Who can help me with that? Every imput is very much appreciated.