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,

Compare Values
Beyond compare - Download - File management
Excel compare two sheets - Guide
Vba colorindex values - Guide
Winmerge pdf compare - Software Forum
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum

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

Fill adjacent cell with number from text answer

Excel function question

Return Seq Values Until Blank value then return different set of seq values

Comparing Two Excel Sheets and copying like data to third sheet

Similar discussions

Subscribe To Our Newsletter!