Hello please help me in this

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
i have data in two sheets sheet1 and sheet2. i want to compare single cell from sheet1 to the entire row of sheet2. please any body can give me the code for this

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
There are many options you can use Vlookup , Index/match but it depends on you what you want .....

Suppose you have data in Sheet1 Column A and want to compare with Sheet2 Column A then use this formula .....

Now you want to compare only CellA1 of Sheet 2 in Sheet1 Column A then write this formula in Sheet2 Cell B1 and if the same cell exist in sheet 1 then it will appear else #NA .......

=VLOOKUP(A1,Sheet1!A:A,1,FALSE)

You can also use this formula .......

=INDEX(Sheet1!A:A,MATCH(Sheet2!A1,Sheet1!A:A,0))