+ Reply to Thread
Results 1 to 4 of 4

lookup year and month to return value

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    lookup year and month to return value

    Hoping an easy solution someone can help me with. Attached is my milage form and the problem I have is im using a pivot table to return a milage figure for each month. All has been good until this year ive reached Jan again as a pivot table only returns the first result location which for me is 2018. I need my attached form to look at the year, then month and return the value in the summary sheet column "H". Can someone help.
    ive made some notes on the attached excel sheet on each tab. The form style I cannot change as this has to be submitted as is
    Attached Files Attached Files
    Last edited by interested; 01-11-2019 at 04:43 AM.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,628

    Re: lookup year and month to return value

    In H9
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    Re: lookup year and month to return value

    Many thanks for the answer !! simple when you know how. I really need to get my head around functions like index and match.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,454

    Re: lookup year and month to return value

    Just remember ( that is not always clear in the explanations on the Net), that INDEX on its own returns the value of a cell. Embedded in a formula it returns the cell reference to the formula enabling you to build interesting formulas

+ 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. Lookup value according to Year & Month
    By beneesetas14 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-28-2014, 07:27 AM
  2. [SOLVED] Return month based on day of the year
    By Marco-Kun in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 03-27-2014, 11:58 AM
  3. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM
  4. [SOLVED] Create Fiscal Year - Lookup Date in Fiscal Month Date Range and Return EOM Date
    By gbriscoe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2013, 03:29 PM
  5. return last month's year
    By bassima in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2012, 01:29 AM
  6. Type in Month-Year and return 3rd wednesday of month
    By learntheweek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2010, 11:29 AM
  7. Formula to return last day of month for each month in year?
    By StargateFan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-03-2006, 12:10 AM

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