Merging tables

[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 (e-mail address removed)
102 rita (e-mail address removed)
...
999 jim (e-mail address removed)

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

 

[Guest]

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
(e-mail address removed)
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 (e-mail address removed)
102 rita (e-mail address removed)
..
999 jim (e-mail address removed)

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