Excel 2010 IF(VLOOKUP... 1

[PWD]

Good afternoon, I had wondered if it were possible to construct a formula that would save the user having to deal with "#N/A" and just leave them with the Boolean result. Naively I have put this together but it still just returns "#N/A" when VLOOKUP is unsuccessful - and I can see why.

=IF(VLOOKUP(B2,$C$7:$C$8,1,0)<>"#N/A","Yes","No")

Is there something that would work as I'd like?

Many thanks,
D€$

 

[SkipVought]

What VERSION Excel ?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[SkipVought]

=ISNA()

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[PWD]

=IF(ISNA(VLOOKUP(B3,$C$7:$C$8,1,0)),"No","Yes")

Boom!

Many thanks,
D€$

 

[SkipVought]

It's really a MATCH issue...
[tt]
=ISNA(MATCH(B3,$C$7:$C$8,0))
[/tt]
...returns TRUE or FALSE

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[PWD]

Hi Skip, I'm sure it is but mine returns "Yes" or "No" which is what I want the user to be able to see; and then they could have a simple

=COUNTIF(H2:H10000,"Yes")

Or a COUNTIFS to select other criteria for a 'Summary' worksheet.

Many thanks,
D€$

 

[SkipVought]

=COUNTIF(H2:H10000,TRUE)

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[PWD]

I get what you mean Skip, but you know what users are like; "The old report used to be "Yes" or "No". Just trying to keep my customers satisfied.

Many thanks,
D€$

 

[SkipVought]

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}