Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,090
    Articles
    79
    Blog Entries
    14
    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.)
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Quote Originally Posted by Ken Puls View Post
    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
  •