Questions

Answer for:

How do I combine 2 spreadsheets that have 1 field in common?

Message 2 of 12

View entire thread
+
0 Votes
TobiF

Are you sure that you have exactly one contact record for each company?

If not, then have a look at relational databases, for instance Access.

You can use lookup functions.
If the index value your searching for is in cell G1, the other list has the index value in column A and the value you want to copy in column C
=LOOKUP(G3;$A$2:A7;$C$2:$C$7)
The dollar signs are needed to not have the lookup and result vectors "slide" with your function when you copy it.

Same formula if you're building on a different sheet.
=LOOKUP(A1;Sheet1!$A$2:$A$6;Sheet1!$C$2:$C$6)

Better than "dollar" addresses is to use named ranges.