+ Reply to Thread
Results 1 to 2 of 2

Xlookup returning value based on date

  1. #1
    Registered User
    Join Date
    05-27-2022
    Location
    Toronto
    MS-Off Ver
    Office 365
    Posts
    4

    Xlookup returning value based on date

    I am trying to create an XLOOKUP formula that returns a value based on the date. The data table I am working with has the last 12 rows in the table as forecasted sales which starts with the current month and gives forecasted sales for the next 11 months. What I want to do is have a dropdown menu of months that will allow the user to pick what month the XLOOKUP function will look for. For example, if I choose June the formula will return the relative value in the column with header 2022-06-01 on the table.

    I am open to any suggestions on how to generate this. Many thanks in advance.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,998

    Re: Xlookup returning value based on date

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ 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] xlookup not returning value due to looking up dates
    By dharvey1978 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2022, 03:11 AM
  2. XLOOKUP not finding/returning matches on X & Y axis.
    By JamesParkerDC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2022, 12:13 PM
  3. returning date from column based on max value in a row
    By gdarling in forum Excel General
    Replies: 4
    Last Post: 01-13-2021, 11:42 AM
  4. [SOLVED] XLookup returning wrong values when using two conditions
    By Einrastor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2020, 07:38 AM
  5. Returning Date based off Value
    By KevinYuen08 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2019, 12:45 PM
  6. Returning a value based on the date
    By sungen99 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-01-2015, 12:44 PM
  7. Returning Values based on date falling between Date ranges
    By honest1122 in forum Excel General
    Replies: 5
    Last Post: 06-29-2012, 05:10 PM

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