Formula to return value of Y if criteria is met. No value returned is criteria isn't met.

[RodneyW]

I'm trying to work with this formula:

=IF(ISNA(VLOOKUP($B6,News!$E:$F,2,FALSE)),"N","Y")

Here's what I'm expecting... When it finds the value in $B6 in the News sheet in column E it will look in the second column (F) If there is no value there, it will return no value, meaning the cell where the formula is will be empty. On the other hand, if it finds a value in F it will return a value of "Y".

Here's what's happening. Regardless of whether there is a value in F I'm getting a "Y" in every cell as I drag the formula down.

Any ideas?

Thanks in advance

 

[Oaktree]

VLOOKUP will return #N/A if B6 doesn't match anything in column E. That doesn't sound like the criterion you're looking for.

Instead, try:

=IF(VLOOKUP($B6,News!$E:$F,2,FALSE)="","N","Y")

 

[RodneyW]

VLOOKUP will return #N/A if B6 doesn't match anything in column E. That doesn't sound like the criterion you're looking for.

Instead, try:

=IF(VLOOKUP($B6,News!$E:$F,2,FALSE)="","N","Y")

And like magic, problem solved. Thank you