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
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Vba colorindex values - Guide
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

Clear cell contents based on value of another cell range using VBA

Similar discussions

Subscribe To Our Newsletter!