Previous Topic Next Topic

Compare Values

Closed
jsmahender Posts 2 Registration date Tuesday August 4, 2009 Status Member Last seen August 5, 2009 - Aug 5, 2009 at 10:15 AM
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 - Aug 12, 2009 at 06:24 AM
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 response

Answer 1 / 1
kaiyasit Posts 30 Registration date Sunday August 9, 2009 Status Member Last seen April 20, 2010 12
Aug 12, 2009 at 06:24 AM
Absolutely,You can use VLOOKUP() function

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response