Home > Forum Home > Analyzing Corporate Financial Data > VLOOKUP with dates Share

VLOOKUP with dates

Excel Help for Vlookup With Dates in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Vlookup With Dates

Rate this:
(3/5 from 1 vote)
Confusedi urgently need to know how to use the VLOOKUP function for a specific problem:

i have a list of dates, eg
01-Jun-07
06-Jul-07
10-Aug-07

and a separate table, with a number corresponding to each month of the year, eg
1   January
2   Feburary
3   March
4   April
etc
the number value and the month are in separate columns.


i need to create a VLOOKUP function to associate the date with it's month's number value.
please help me, this is really urgent!
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(3/5 from 1 vote)
When you do your VLOOKUP instead of using the date value to look up, wrap it in a =MONTH function so that it returns the number of the month that can be matched against the month number in your second table.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
I have the same problem but I need to check if a list matches the Month and the year.  I'm trying to have a cell on a separate sheet return a true or a false if the date falls within the month.

 ie. List of dates that tool change is required
 10-Mar-09         06-May-09        22-Jan-10       12-Feb-10

 on a separate sheet i'm trying to search the dates above to see if there is a tool change required during the month

 Jan-09   Feb-09   Mar-09  Apr-09
 FALSE    FALSE     TRUE    FALSE

 I can calculate all the machines that have a true vales and the amount of tools on each that need to be changes for that month.


 James
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for VLOOKUP with dates in the