Results 1 to 5 of 5

INDEX + MATCH: Please help!!

Threaded View

  1. 08-28-2017, 11:17 PM #1
    sabmitchell
    sabmitchell is offline
    Registered User
    Join Date
    08-28-2017
    Location
    Oregon, USA
    MS-Off Ver
    Office 2016
    Posts
    2

    Exclamation INDEX + MATCH: Please help!!

    I am trying to create a form that will calculate the price of travel based on the resort and travel dates, in reference to the price list for several resorts broken down by travel dates for price.

    I believe I have the correct formula but it keeps coming back as "N/A"

    In the travel dates the date in the header is the last date of travel for the corresponding price below. What am I doing wrong?

    =INDEX(G3:J10,MATCH(B2,F3:F10,0),MATCH(B3,G2:J2,1))
    Attached Images Attached Images
    Last edited by sabmitchell; 08-29-2017 at 09:52 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX+MATCH instead of VLOOKUP+MATCH, why is INDEX a better choice and how to re-write?
    By Renejorgensen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2016, 10:54 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  5. Problems with multi-criteria Index/Match. LOOKUP works. Index/Match, SUMPRODUCT,ARRAY fail
    By sfike in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. Index, match, dynamic and connected without sorting helper column non-adjacent index match
    By Underling in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. [SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings
    By bkwins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:31 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1