Compare Values

Closed
Report
Posts
2
Registration date
Tuesday August 4, 2009
Status
Member
Last seen
August 5, 2009
-
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
-
Hello,
Good evening admin(s) and members,

i need a formula to check a particular value whether it exists in entire colomn a1=143, a2=145, a3=158,
and b1=158.

In this i need a formula to check whether B1 i.e., 158 exists in entire A Colomn like A1:A5, if it exists, then true else false.

hope you got my point.

Thanking you,

1 reply

Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Absolutely,You can use VLOOKUP() function
0