Help matching fields in a database

**simjambra** · 03-13-2009, 12:04 PM

Hi there, I am after a bit of advice here.

I have bought a database with two non-related tables.

I am transferring this data over to excel but I am not sure what to do with linking the information.

The fields in one table are

Company Name--- Address---Phone---email

The fields in the other table are

Contact Name----Organisation

The Company name and the Organisation name will often match so have you any idea how I would link these?

Thanks

**Special-K** · 03-13-2009, 12:13 PM

Assuming Company in first table is sorted and matches exactly the Organisation in the second table

you could add in column C of second table

Col C
=VLOOKUP(B1,Sheet1!$A$1:$B$65535,2)
Col D
=VLOOKUP(B1,Sheet1!$A$1:$B$65535,3)
Col E
=VLOOKUP(B1,Sheet1!$A$1:$B$65535,4)

**simjambra** · 03-13-2009, 12:28 PM

Originally Posted by Special-K

Assuming Company in first table is sorted and matches exactly the Organisation in the second table

you could add in column C of second table

Col C
=VLOOKUP(B1,Sheet1!$A$1:$B$65535,2)
Col D
=VLOOKUP(B1,Sheet1!$A$1:$B$65535,3)
Col E
=VLOOKUP(B1,Sheet1!$A$1:$B$65535,4)

I will keep trying. Doesn't help when there are 180000 records