+ Reply to Thread
Results 1 to 5 of 5

Helps with VLOOKUP formula with correct column matching if a date is given

  1. #1
    Registered User
    Join Date
    05-02-2014
    Location
    Malaysia
    MS-Off Ver
    Office 365 version 2203
    Posts
    10

    Question Helps with VLOOKUP formula with correct column matching if a date is given

    Hi, I have two workbooks called "A"(Source) and "VLOOKUP_A"(Destination) as shown in the XLBB format.
    Basically in the VLOOKUP_A workbook, I would like to apply VLOOKUP formula to extract info from the source workbook "A".

    However, the formula has to be able to recognize the correct date and then only can further take the rest of the column data following the correct date. As the headers after the date are the same as the others, only the date header will be changing every week when new columns are added. Would like to learn how can I use VLOOKUP to do what I want or if there is another better alternative solution for my case. Thank you.

    Workbook "A" (Workbooks uploaded here as well)
    A.png

    Workbook "VLOOPUP_A"
    V_A.png
    Attached Files Attached Files
    Last edited by jaden5165; 04-15-2022 at 08:35 PM.

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

    Re: Helps with VLOOKUP formula with correct column matching if a date is given

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are relatively inexperienced here, I will do it for you this time: https://www.mrexcel.com/board/thread...given.1202113/)
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    05-02-2014
    Location
    Malaysia
    MS-Off Ver
    Office 365 version 2203
    Posts
    10

    Re: Helps with VLOOKUP formula with correct column matching if a date is given

    Hi Ali,

    Sorry for my mistake and thank you for your help on this. Will not repeat the same mistake again.
    Thank you.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Helps with VLOOKUP formula with correct column matching if a date is given

    I replaced =RAND() with fixed values... it's hard to remember ever-changing values!

    =IFERROR(VLOOKUP($A3,[A.xlsx]ANALYSIS!$A:$Z,MATCH($B$2,[A.xlsx]ANALYSIS!$A$2:$Z$2,0)+COLUMNS($B3:B3)-1,FALSE),"")

    picks up the date in B2 and then moves to the right...

    Copy across and dnown.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  5. #5
    Registered User
    Join Date
    05-02-2014
    Location
    Malaysia
    MS-Off Ver
    Office 365 version 2203
    Posts
    10

    Re: Helps with VLOOKUP formula with correct column matching if a date is given

    Hi Glenn,

    Thanks for the formula and I am able to use your formula to further make it to what I really want.
    Learnt new thing

+ 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] TWOWAY VLOOKUP - matching date in row and name in column
    By Nadimtukin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2021, 03:56 AM
  2. [SOLVED] Unable to select the correct formula (IF or VLOOKUP) to get results in column B
    By Larisa89 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-17-2019, 06:13 AM
  3. [SOLVED] Formula to automatically pull total into correct date column
    By krisryan in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 01-24-2018, 11:07 PM
  4. [SOLVED] Formula not matching to correct date in price history
    By Ochimus in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 02:10 PM
  5. Replies: 4
    Last Post: 04-19-2015, 03:52 PM
  6. MS EXCEL Formula - Helps with 1 cell right of Matching Cell
    By Solly Elias in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-28-2013, 10:56 AM
  7. Replies: 12
    Last Post: 01-31-2013, 03:30 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