Lookup value
 

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

Lookup value
 

"SF" wrote in message
...
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)

Lookup value
 

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" <none wrote in message
...
"SF" wrote in message
...
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)

Lookup value
 

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

"SF" wrote in message
...
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" <none wrote in message
...
"SF" wrote in message
...
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)