please help me to find the right data from match row and column

mtsf26

New member
Joined
Nov 4, 2011
Messages
2
Reaction score
0
Points
0
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.
 

Attachments

  • m3.xlsx
    12.2 KB · Views: 11
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.)
 
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.:)
 
Back
Top