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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
Comparing columns and returning value
ll -
kittu -

35 responses
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses
Macro to compare 2 sheets and copy differences
ehusar -
AirMaple -

2 responses