matching rows from two tables

**karleek** · 05-27-2009, 04:42 AM

Hello!

Is there anyone able to help me with this problem?
I have two tables with about 900 rows. Both the tables have the same first column (names of groundwater wells), but they are differently organized and not possible to align in the same manner (alphabetically, etc...) because the names contain letters and numbers. In the second column of the second table I have another identification of these wells (11 digit numbers) which I want to transfer to the first table (the right number to the right well).
Could anyone help me to find the very match in the two tables to get the right codes to their wells? I could get the three columns of interest to the same sheet of course - I just need to organize the wells' names and codes from the second table in the same way as I have the names in the first table.

Thanks for consideration!!

k

**zbor** · 05-27-2009, 04:44 AM

can you uplaod an example?

**DonkeyOte** · 05-27-2009, 05:29 AM

Take a look at the VLOOKUP function in XL Help, ie assuming:

Table1: Sheet1 Column A

Table2: Sheet2 Columns A & B

Sheet1
B1: =VLOOKUP(A1,Sheet2!A:B,2,0)
copied down

would retrieve the value from Column B on sheet2 where the value in Column A on Sheet2 equalled the value of A1 on Sheet1.

**karleek** · 05-27-2009, 05:30 AM

Thanks for Your time!

There You go with the example.
Simply: column A = few wells I want to add the ID to; column C = all my wells & their ID in column D.

How to automatically assign the right ID to the wells in the OBJECT (column A)?

Thanks again!

k

**DonkeyOte** · 05-27-2009, 05:35 AM

Adapting the earlier VLOOKUP example

B2: =VLOOKUP(A2,C:D,2,0)
copied down

Note: where the Well does not exist in Column C you will get an #N/A
You can handle this using:

=IF(ISNA(MATCH(A2,C:C,0)),"n/a",VLOOKUP(A2,C:D,2,0))

change "n/a" to be whatever you want to appear where the value in A is not found in C