+ Reply to Thread
Results 1 to 3 of 3

Range of dates for Vlookup

  1. 04-21-2016, 08:06 PM #1
    controlrex is offline
    Registered User
    Join Date
    04-19-2016
    Location
    Auckland
    MS-Off Ver
    2006
    Posts
    7

    Range of dates for Vlookup

    Hey guys, I'm wondering why how do you guys create two input boxes for range of dates and which can filter up my product quantity on hand based on opening date and closing date.

    Details are provided in the pictures.

    Admin.PNG
    table.PNG
    Last edited by controlrex; 04-21-2016 at 08:39 PM.
    Reply With QuoteRegister To Reply
  2. 04-21-2016, 08:22 PM #2
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,462

    Re: Range of dates for Vlookup

    Just create a Pivot Table. You can filter what you want then.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 04-21-2016, 08:38 PM #3
    controlrex is offline
    Registered User
    Join Date
    04-19-2016
    Location
    Auckland
    MS-Off Ver
    2006
    Posts
    7

    Re: Range of dates for Vlookup

    PivotTable doesn't update by itself, Sadly
    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. VLOOKUP for a range of dates
    By skillsguy in forum Excel General
    Replies: 5
    Last Post: 02-03-2015, 03:53 AM
  2. [SOLVED] Vlookup on Dates and generating date range based upon inputs
    By Chardo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2014, 05:13 PM
  3. Check dates in range either same dates or different dates by formula
    By breadwinner in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2013, 07:42 AM
  4. vlookup range based on cell values / vlookup range start/end point?
    By kmfdm515 in forum Excel General
    Replies: 6
    Last Post: 09-04-2012, 10:35 AM
  5. Excel 2007 : Using VLOOKUP to find a range of dates
    By vjpemberton13 in forum Excel General
    Replies: 3
    Last Post: 04-18-2012, 02:50 PM
  6. Workday and Vlookup to select a range of holiday dates
    By vadius in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-29-2011, 10:28 AM
  7. vlookup over range of dates
    By Chuckers in forum Excel General
    Replies: 3
    Last Post: 02-02-2010, 10:18 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