+ Reply to Thread
Results 1 to 2 of 2

Index and Match Question

  1. #1
    Registered User
    Join Date
    09-30-2014
    Location
    Denver, CO
    MS-Off Ver
    2009
    Posts
    60

    Index and Match Question

    Please see attached. I have my Index/Match formula for Hotel Room Nights but now need to do the same formula for Revenue.

    My brain is turned off for today. What needs to change in the second column to retrieve revenue rather than room nights?

    -Mitch
    From snowy Denver Colorado
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Index and Match Question

    match +4 ?

    =INDEX($D:$D,MATCH(I2,$A:$A,0)+4)

+ Reply to 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 Question
    By chisox721 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2013, 05:15 AM
  2. Index, match, match Question!. Seems so simple but can't figure it out...
    By huikimhuikim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2013, 01:57 PM
  3. Index/Match question
    By mikera in forum Excel General
    Replies: 2
    Last Post: 10-22-2010, 02:03 PM
  4. Index/match question.
    By Jules in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-06-2006, 01:50 PM
  5. [SOLVED] Index/Match question Need help!
    By Brian H in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2005, 09:05 PM

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