Merging tables

B

bro

Hello, I do not have deep knowledge of Excel. That is why my proble
might appear a bit strange:

I have two tables, list1 and list2. In both tables there is a colum
with unique ID numbers. The rest of the columns contains differen
information in both tables. Example:

list1
-----
ID name email
101 bob [email protected]
102 rita [email protected]
...
999 jim [email protected]

list2
-----
ID salary
102 2000
103 2500
...
204 2100

What I would like to get as a result is a combined table, with selecte
columns from both tables in it. I.e.:

list3
-----
ID name salary
101 bob -
102 rita 2500
...

Anyone who can help me out? Thank you very much! (Excel 2000, releas
9.0)

Ul
 
M

Mark Graesser

Hi Ulf
You could add a new column to your list1 and enter a VLOOKUP function

=VLOOKUP(cell_reference of ID#, range_of_list2,2,False

If you want a dash to show up if the id# isn't in list two then use

=IF(ISERROR(VLOOKUP(cell_reference of ID#, range_of_list2,2,False)),"-",VLOOKUP(cell_reference of ID#, range_of_list2,2,False)

Good Luck
Mark Graesse
[email protected]
Boston M

----- bro > wrote: ----

Hello, I do not have deep knowledge of Excel. That is why my proble
might appear a bit strange

I have two tables, list1 and list2. In both tables there is a colum
with unique ID numbers. The rest of the columns contains differen
information in both tables. Example

list
----
ID name emai
101 bob [email protected]
102 rita [email protected]
..
999 jim [email protected]

list
----
ID salar
102 200
103 250
..
204 210

What I would like to get as a result is a combined table, with selecte
columns from both tables in it. I.e.

list
----
ID name salar
101 bob
102 rita 250
..

Anyone who can help me out? Thank you very much! (Excel 2000, releas
9.0

Ul
 
Top