+ Reply to Thread
Results 1 to 3 of 3

Need to use MATCH and INDEX over 2 worksheets

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Need to use MATCH and INDEX over 2 worksheets

    Hello,

    I am trying to match 2 columns in my data worksheet from a list of items from a different worksheet. I need the size and material to match up equally in one row from 2 columns of data on a separate worksheet to get the correct price from the last column. If I place all the data on one worksheet the INDEX function works like a charm. But unfortunately, all of my data is on a separate worksheet. When I try to use the same formula with a separate worksheet, it doesn't work. Here are the formulas I was trying to use:

    If all the data is on the same page the following formula pulls the answer I need:

    =INDEX(D7:D9,MATCH(F4,B7:B9,0),MATCH(G4,C7:C9,0)))

    But I want to pull this same data from a separate worksheet and when I plug it in that way I get #REF!.

    =INDEX(D7:D9,MATCH(F4,'Steel 2012'!B4:B281,0),MATCH(G4,'Steel 2012'!C4:C281,0))

    Could it be that one column is numbers and the other has numbers & letters?

    Help. :/

  2. #2
    Forum Contributor Legend Rubber's Avatar
    Join Date
    09-21-2012
    Location
    Tillsonburg, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    392

    Re: Need to use MATCH and INDEX over 2 worksheets

    Can you attach a sample workbook?

  3. #3
    Registered User
    Join Date
    12-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Need to use MATCH and INDEX over 2 worksheets

    Yes, please see attached document. I need the Price/Lbs column to find the exact size and material (highlighted on the Data sheet) from the Steel Worksheet and return to me the corresponding price/lb for that criteria.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1