How to search for a value in a range of cells as a Function
Posted by Mark on October 09, 2001 9:33 AM
Is there a function to search a range of cells for a text value and return TRUE or FALSE in an adjoining column?
I have Col A with 500 values in A1:A500. I want to search for the value that equals the one in B1 (using a formula/function in C1). If it matches, then return TRUE, is not return FALSE or blank in C1.
It'd be even better if I knew the cell reference where the search returned true.
A B C
1 1234567 8877662 TRUE
2 8877662 1000000 FALSE
3 2233445 2000000 FALSE
4 1155779 3000000 FALSE
5 1125678 4000000 FALSE