+ Reply to Thread
Results 1 to 2 of 2

Vlookup on data table based on month + year to date

  1. #1
    Registered User
    Join Date
    04-01-2020
    Location
    Ostend
    MS-Off Ver
    O365
    Posts
    14

    Vlookup on data table based on month + year to date

    Dear,

    See test in attachment.

    I want a vlookup in cell D and cell I (row 6) for budget variance. Vlookup on costid is no problem, actuals are no problem by combining sumifs function.

    Concrete question 1 =>

    How do I get the Vlookup on D6 based on month D3
    Example => information in V1:D6 if V1:D3 is February 2022 => Budget!D2
    Example => information in V1:D6 if V1:D3 is August 2022 => Budget!J2

    Concrete question 2 =>

    How do I get the Vlookup on I6 based on month D3 till year to date (D3)
    Example => Information in V1:I6 if V1:D3 is February 2022 => Budget!C2 + Budget!D2
    Example => Information in V1:I6 if V1:D3 Is August 2022 => Budget!C2 till Budget!J2 in sum
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Vlookup on data table based on month + year to date

    OK. I changed D6 to be this formula:

    Please Login or Register  to view this content.
    I changed I6 to be this formula:

    Please Login or Register  to view this content.
    Does that achieve what you want?

    WBD
    Office 365 on Windows 11, looking for rep!

+ 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. Replies: 1
    Last Post: 02-28-2020, 04:15 AM
  2. Replies: 3
    Last Post: 06-26-2019, 11:46 AM
  3. Populating table based on month & year only
    By VBAhelp3456 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2015, 06:27 AM
  4. Need to convert Month/Date/Year to Year/Month/Date so excel will recognize
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2014, 04:17 PM
  5. Extract data based on month/year to a simple table.
    By maax555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2014, 09:55 AM
  6. Vlookup Month and Year in a Date
    By deanstein in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-14-2012, 12:52 PM
  7. Retrieving data from two pivot tables based on date (grouped by month and year)
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-05-2010, 04:37 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