find a alphanumeric in a list

[2226]

I have a column in which there are alphanumerical in cell B10 to B20 (red 3,
red4, red6, red9, red10, red 15, red17, red18, red20, red23). I have cell in
which the input has given say cell A10 (red5) & I have a cell which will tell
whether input in A10 is present from the B10 to B20 or not say cell S10. If
I’m putting the logic statement in cell S10 the logic should results in
“false†or “trueâ€.

 

[Pete_UK]

No need to start another thread - check your previous thread.

Another approach is to use MATCH:

=ISNUMBER(MATCH(A10,B10:B20,0))

but you must be more consistent with your data, as you are looking for
exact matches.

Hope this helps.

Pete

 

[Shaun]

Please check whether the below mentioned formula is ok for u

In C:10 to C:19 type the value as true.

=IF(A10="","",VLOOKUP(A10,B10:C19,2,"FALSE"))

Byee.

Shaun