+ Reply to Thread
Results 1 to 3 of 3

Lookup data based on Date & Name

  1. 11-29-2021, 04:41 PM #1
    mkhalil
    mkhalil is offline
    Registered User
    Join Date
    07-07-2019
    Location
    Bangladesh
    MS-Off Ver
    365
    Posts
    12

    Lookup data based on Date & Name

    Hi,

    I have attached a sheet where the list of products according to the date and names will come out on cell K8 to K10 from the RAW Data.


    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-29-2021, 07:35 PM #2
    GeoffW283
    GeoffW283 is offline
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: Lookup data based on Date & Name

    Maybe the following in K9:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    This is an array formula and as you have the 2019 version of Excel it must be committed via CTRL-SHIFT-ENTER.

    Copy down to K10.
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select ?Solved? from the Thread Tools menu
    Reply With QuoteRegister To Reply
  3. 11-29-2021, 11:33 PM #3
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,515

    Re: Lookup data based on Date & Name

    based on Date & Name

    Cell K8 array formula , drag down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 based on closest date either side of a date
    By RollingStone88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2019, 08:38 AM
  2. [SOLVED] Lookup/Match from 2 worksheet & populate data based on lookup
    By plcouch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2015, 08:16 PM
  3. [SOLVED] Formula to lookup Date based on Date in cell D1
    By rizmomin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-23-2014, 05:36 PM
  4. [SOLVED] Formula to Lookup value based on date within a date range
    By MHamid in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2013, 02:24 PM
  5. [SOLVED] Lookup date and condtional format colour based on date
    By Smudge.Smith in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-25-2013, 08:38 AM
  6. Lookup data based on date, paste in different workbook based on date
    By dobombmsu in forum Excel General
    Replies: 2
    Last Post: 09-20-2010, 02:51 PM
  7. Lookup data from multiple sheets, based a on date
    By Joshua@work in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-29-2010, 07:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1