Vlookup - Maybe

[RodneyC]

I'm trying to use VLOOKUP where if the condition is met, return a value of Y. If it's not met, return a value of N

This produces the Y but produces the #N/A value if the condition is not met. How do I modify my formula so it produces N instead on #N/A?

Thank you in advance

 

[Joe4]

You could do something like:

=IFERROR(VLOOKUP(...),"N")

But I think I could probably use a COUNTIF instead, i.e.

=IF(COUNTIF(...)>0,"Y","N")

 

[RodneyC]

You could do something like:

=IFERROR(VLOOKUP(...),"N")

But I think I could probably use a COUNTIF instead, i.e.

=IF(COUNTIF(...)>0,"Y","N")

YAHTZEE! The first option worked like a charm. Thank you

 

[Joe4]

You are welcome.

The reason I prefer the second option is because the first will ignore ANY error, not just an #N/A error.
So you could ignore other errors that you may want to know about.

 

[RodneyC]

Thanks for the follow up. I've entered this

=IF(COUNTIF(B4,InclusionList!$A$2:$E$32,5,FALSE)>0,"Y","N")

and it's telling me "You've entered too many arguments for this function"

There is a shortcoming of the VLOOKUP solution that if we get the COUNTIF working, I'll outline in a separate post.

 

[Joe4]

The COUNTIF function structure is NOT the same as the VLOOKUP strucutre. So you cannot just swap out the two words! You need to put the correct arguments in the correct place.
See: MS Excel: How to use the COUNTIF Function (WS)

So I think your formula will need to look like:

=IF(COUNTIF(InclusionList!$A$2:$A$32,B4)>0,"Y","N")

 

[RodneyC]

The COUNTIF function structure is NOT the same as the VLOOKUP strucutre. So you cannot just swap out the two words! You need to put the correct arguments in the correct place.
See: MS Excel: How to use the COUNTIF Function (WS)

So I think your formula will need to look like:

=IF(COUNTIF(InclusionList!$A$2:$A$32,B4)>0,"Y","N")

That is working perfectly. I'll post the new question in a new post in a couple minutes I appreciate the help