+ Reply to Thread
Results 1 to 10 of 10

Thread: Index, match

  1. 02-07-2012, 10:30 AM #1
    mheinmiller
    mheinmiller is offline
    Registered User
    Join Date
    09-24-2007
    Posts
    49

    Index, match

    I am trying to find a formula the looks up 2 parameter (one is a range) and returns the value. I just cant seem to get it to work.

    I have attached my sample.

    any help would be greatly appreciated!

    My file has errors in C6,C7 &C8 ... sorry, I deleted too much before uploading
    Estimate Miles 394
    Estimate to Zip 39201
    Estimate to City Jackson






    Test Pricing.xlsx
    Last edited by mheinmiller; 02-07-2012 at 11:12 AM. Reason: SOLVED
    Reply With Quote Reply With Quote
  2. 02-07-2012, 10:37 AM #2
    Fotis1991
    Fotis1991 is offline
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,297

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    Hi

    In pricing sheet!, cells C6,C7 &C8, gives me an error.!!

    wHICH ARE THESE FORMULAS?
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/
    Reply With Quote Reply With Quote
  3. 02-07-2012, 10:42 AM #3
    GeneralDisarray
    GeneralDisarray is offline
    Valued Forum Contributor GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2007/2010/2011
    Posts
    310

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    the Vlookup references are gone in the attachment (#ref indicates missing table). what exactly are you looking up from?
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.
    Reply With Quote Reply With Quote
  4. 02-07-2012, 10:55 AM #4
    mheinmiller
    mheinmiller is offline
    Registered User
    Join Date
    09-24-2007
    Posts
    49

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    UGH ... so sorry! i deleted too much
    State Estimated Wt
    MS-Mississippi 1400

    Estimate Miles from 394
    Estimate to Zip 39201
    Estimate to City Jackson
    Reply With Quote Reply With Quote
  5. 02-07-2012, 11:02 AM #5
    Fotis1991
    Fotis1991 is offline
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,297

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    Would you like to re-upload the sample??
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/
    Reply With Quote Reply With Quote
  6. 02-07-2012, 11:04 AM #6
    mheinmiller
    mheinmiller is offline
    Registered User
    Join Date
    09-24-2007
    Posts
    49

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    Test Pricing2.xlsx
    here is the correct one. sorry ...
    Reply With Quote Reply With Quote
  7. 02-07-2012, 11:07 AM #7
    OnErrorGoto0
    OnErrorGoto0 is offline
    Valued Forum Contributor OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,647

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    =INDEX(Av!B10:CT134, MATCH(C3,Av!A10:A134,1),MATCH(C7,Av!A1:CT1,0))

    I think is what you want.
    Good luck.
    Reply With Quote Reply With Quote
  8. 02-07-2012, 11:09 AM #8
    bebo021999
    bebo021999 is offline
    Valued Forum Contributor
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    455

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    Try this in B14:
    =INDEX(Av!B10:CT134, MATCH(C3,Av!A10:A134),MATCH(C7,Av!A1:CU1,0))
    Click the star icon in left-corner of my post if you find my post userful!

    Quang PT
    quangphanidico@yahoo.com
    PM me: Y!M: quangphanidico
    Reply With Quote Reply With Quote
  9. 02-07-2012, 11:10 AM #9
    mheinmiller
    mheinmiller is offline
    Registered User
    Join Date
    09-24-2007
    Posts
    49

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    THANK YOU so much!
    Reply With Quote Reply With Quote
  10. 02-07-2012, 11:10 AM #10
    Fotis1991
    Fotis1991 is offline
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,297

    Re: Index, match ... trying to look up 2 parameters (one is a range) and return value

    try this.

    =INDEX(AV!B10:CT134, MATCH(C3,AV!A10:A134),MATCH(B3,AV!B3:CT3))
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0