If value found display X, else Y

Hello,

I want to search for a specific cell content (BC1) in a row (B46:V46). If found, I want to display let's say "X", else "Not Found".

I guess it looks something like this:

=IF(ISNA(HLOOKUP(BC1, $B$46:$V$46, 46)), "Not Found", "X")

but...

N-ter,

Give the following a try:
=IF(ISNUMBER(MATCH(BC1,B46:V46,0)),"X","Not Found")

Hope that helps,
~tigeravatar

try MATCH formula

=IF(ISNUMBER(MATCH(BC1, $B$46:$V$46, 0)), "X", "Not Found")

It works, thanks guys.