Comparing 2 rows of diff sheets

Microsoft Book: office excel 2003 step b...
August 11, 2009 at 00:43:14
Specs: Windows XP

I have 1 row in worksheet1 and 2 rows in worksheet2. I want to comapre 1 row of sheet 1 with first row of 2nd sheet. If match found then need to get corresponding value of 2nd row from the 2nd sheet................

Its very urgent......... Please help me by providing formula for the same...


See More: Comparing 2 rows of diff sheets

Report •

August 11, 2009 at 06:55:57
re: Its very urgent

Just a suggestion: Using words like "urgent" is not going to get you a faster response, in this forum or any forum. We respond as time allows, if and when we think we can help. You might even turn a few people away by implying that your question is more important than anyone else's.

Have you tried using HLOOKUP?


If you don't want the #NA errors if the value isn't found, use this:



=IF(ISNA(HLOOKUP(A1,Sheet2!$A$1:$I$2,2,0)),"Not Found",HLOOKUP(A1,Sheet2!$A$1:$I$2,2,0))

Report •
Related Solutions

Ask Question