hey everybody..
i have a problem about excel formula. im going to find the right data which the source is in other sheet and from that source table we must find the match data that we got from comparing one row and one column.how to make the formula to get the right data?i've attached the excel file too.thanks in advance.

2. Hi there, and welcome to the forum.

If I follow what you're asking here, you can use this formula:
=INDEX(Sheet3!\$B\$2:\$H\$8,MATCH(A3,Sheet3!\$B\$2:\$B\$8,FALSE),MATCH(B3,Sheet3!\$B\$2:\$H\$2,FALSE))

BUT... you need to unmerge cells B1:B2 on Sheet3 first. (Word of advice, avoid merging cells whenever you can, as they just play havoc in Excel.)

3. Originally Posted by Ken Puls
Hi there, and welcome to the forum.

If I follow what you're asking here, you can use this formula:
=INDEX(Sheet3!\$B\$2:\$H\$8,MATCH(A3,Sheet3!\$B\$2:\$B\$8,FALSE),MATCH(B3,Sheet3!\$B\$2:\$H\$2,FALSE))

BUT... you need to unmerge cells B1:B2 on Sheet3 first. (Word of advice, avoid merging cells whenever you can, as they just play havoc in Excel.)
great..it work..thnaks for the advice and the solution.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•