| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested vlookup does not work
Hi,
I have the following situation: We have a list with all personnel and a list with members of Pensionfund. We need to indicate with "No" the empty records and the records with 4 which means ex member. Where must I indicate the 4, if I put it with a comma before the false it is invalid. the 4th column contains the values. =IF(VLOOKUP(A936,'PF members'!A:D,4,4,FALSE)="","No","Yes") Plse HELP. Thanks, Lupe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested vlookup does not work
First, you have too many arguments in your VLOOKUP. I'm not clear on the
rest of what you want so can't assist further until it's clarified. "Lupe" wrote: Hi, I have the following situation: We have a list with all personnel and a list with members of Pensionfund. We need to indicate with "No" the empty records and the records with 4 which means ex member. Where must I indicate the 4, if I put it with a comma before the false it is invalid. the 4th column contains the values. =IF(VLOOKUP(A936,'PF members'!A:D,4,4,FALSE)="","No","Yes") Plse HELP. Thanks, Lupe |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
nested vlookup does not work
Try this:
=IF(OR(VLOOKUP(A936,'PF members'!A:D,4,0)={"",4}),"No","Yes") Biff "Lupe" wrote in message ... Hi, I have the following situation: We have a list with all personnel and a list with members of Pensionfund. We need to indicate with "No" the empty records and the records with 4 which means ex member. Where must I indicate the 4, if I put it with a comma before the false it is invalid. the 4th column contains the values. =IF(VLOOKUP(A936,'PF members'!A:D,4,4,FALSE)="","No","Yes") Plse HELP. Thanks, Lupe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am having difficulty getting nested subtotals to work anymore?! | Excel Worksheet Functions | |||
| Why doesn't the INDIRECT function work when nested in FREQUENCY? | Excel Worksheet Functions | |||
| Nested If workaround - How does it work for other cells dynamicall | Excel Discussion (Misc queries) | |||
| Why doesn't this nested IF statement work? | Excel Worksheet Functions | |||
| Nested IF - Work Around for 7 nest Max | Excel Worksheet Functions | |||
Linear Mode
