Getting a cell match to return FOUND

[wallyxl]

I know I can do this by nesting a load of if statements but I was wondering if there is an easier way.

If in cell A2 I have the value 12 and I want cell A1 to return a value FOUND if any cell from A6 to A24 has the value 12 in it.

Any quick fixes please?

 

[Aladin Akyurek]

I know I can do this by nesting a load of if statements but I was wondering if there is an easier way.

If in cell A2 I have the value 12 and I want cell A1 to return a value FOUND if any cell from A6 to A24 has the value 12 in it.

Any quick fixes please?

=IF(ISNUMBER(MATCH(A2,$A$6:$A$24,0)),"FOUND","Not Available")

 

[wallyxl]

Thank you so much, works a treat.

 

[Aladin Akyurek]

Thank you so much, works a treat.

You are welcome.