nested vlookup does not work

[Guest]

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,4,4,FALSE)="","No","Yes")
Plse HELP. Thanks, Lupe

 

[Guest]

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.

 

[T. Valko]

Try this:

=IF(OR(VLOOKUP(A936,'PF members'!A,4,0)={"",4}),"No","Yes")

Biff