Check if cell values is in one range

[loopoo]

Hello!

I want to know if it's possible to direct check if the value from a cell can be found in the cell of a range, or do I have to compare the value with all the values from the cell in the range???


Thanks in advance,
Chris

 

[BrianB]

There are numerous ways this could be done. See Excel Help "lookup functions"

Here is one which looks for value in cell A1 in range B1:B15 :-
=IF(ISERROR(VLOOKUP(A1,$B$1:$B$15,1,FALSE)),"Not found","Found")

 

[Peter_SSs]

Here is another one:
=IF(ISNUMBER(MATCH(A1,$B$1:$B$15,0)),"Found","Not found")