Previous Topic Next Topic

Hello please help me in this

Closed
baroom - May 18, 2009 at 12:40 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 02:51 AM
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 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 19, 2009 at 02:51 AM
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))

0