Lookup value

[SF]

Hi,

I have two worksheet, both worksheets have in common is the commune code. In
worksheet # 2 has the contact anme related to each commune code.
I want Excel to lookup for name from worksheet # 2 and put the lookup
information in worksheet 1 when the commune code is identical.

Could someone advice what formula I have to use in this case.

SF

 

[Stephen]

Hi,

I have two worksheet, both worksheets have in common is the commune code.
In worksheet # 2 has the contact anme related to each commune code.
I want Excel to lookup for name from worksheet # 2 and put the lookup
information in worksheet 1 when the commune code is identical.

Could someone advice what formula I have to use in this case.

SF

Suppose (just for example) in Sheet2 your commune codes are in A1:A10 and
the corresponding contact names in B1:B10.
In Sheet1, suppose you have a commune name in A1 and want to get the
corresponding contact name to appear in B1. In B1, put the formula
=VLOOKUP(A1,Sheet2!A1:B10,2,FALSE)

 

[SF]

Stephen,

The formula you provided work very well. But I get another #N/A error when
there is no matching value for the cell. Any suggestion to suppress this
error (#N/A) or replacing #N/A with null value?

SF

 

[Stephen]

=IF(ISNA(MATCH(A1,Sheet2!A1:A10,0)),"",VLOOKUP(A1,Sheet2!A1:B10,2,FALSE))