I like this option better for cells that contain text. Because I tried to use a countif when looking for a cell that contain the text "2419.6", but when typing in the formula =COUNTIF(range,"2419.6") it would count only values that are greater than 2419.6 rather than the entered text of "2419.6".
Quote:
Originally Posted by Teethless mama
=OR(INDEX(A1:A3=B2,))
"Pradhan" wrote:
Hi and thanks again for your help out there...
Is there any function to test if a particular value exists in a list?
A simple example: Column A1= car; A2=train; A3=plane
In B2 I place "car". Is there a function which will return TRUE if B2 exists
in A1:A3, or false otherwise?
Thanks
Pradhan
|