| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
