Merging Data

[John]

I have two excel spreadsheets in 2003. I want to search the main spreadsheet
for certain ID code. Once that code is found to dump the associated
information that has 10 separate columns on one row from the second
spreadsheet into new columns in the main sheet.

Example:

Main sheet has 15 columns of personal information with a keycode. Let's says
the keycode I want is 129. In the other sheet I have name, address, province,
country, postal code and key codes. I want to take the customer info
associated with key code 129 and dump into the main sheet in all places that
has the key code 129.

 

[Bernard Liengme]

Let's say the Main worksheet has data in rows 1 to 220 and columns A to 0:
so the table $A$1:$O$220 and that the sheet is called Main. As long as the
key in in the first column we can use VLOOKUP

On the second sheet in A1 you have entered the key to be found (129)
In a cell to the right of this enter =VLOOKUP($A1,Main!$A$1:$O$220,2,FALSE)
to extract the data from column 2 of the table from the row with key 129. To
get data from column 3 use =VLOOKUP($A1,Main!$A$1:$O$220,3,FALSE)

If the key is not in the first column we need to you MATCH and INDEX so
please tell us how the data is arranged if VLOOKUP does not work for you
best wishes