PDA

View Full Version : please help me to find the right data from match row and column

mtsf26
2011-11-04, 02:44 AM
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.

Ken Puls
2011-11-04, 03:10 AM
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.)

mtsf26
2011-11-04, 06:43 AM
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.:)