Check to see if a value exists in a list?
One way...
=COUNTIF(A1:A3,B2)0
--
Biff
Microsoft Excel MVP
"Pradhan" wrote in message
...
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
|