to lookup data for 'today()'

N

nordiyu

e.g

A B C
D
1 Date (From) 01 Jan 2009 01 Feb 2009 01 Mar 2009
2 Date (To) 31 Jan 2009 28 Feb 2009 31 Mar 2009
3 Actual Qty 205 217 300
4 Target Qty 180 250
401


if today = 15 Feb 2009, how to get actual qty using excel formula?
 
B

Bernard Liengme

Put the test date (15-Feb-2009) in a cell, I used A7
In another cell enter =INDEX(B3:M3,MONTH(A7))
This will return 217
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

days calculation between dates 10
Amount with two conditions 0
SUMIF or COUNTIF 1
help with datedif function please 5
Number of hrs worked in a week, based on dates in a different column 1
Subtotal by 2 different criteria 1
Nearest Month 3
Match Both Vertical and Horizontal Conditons 4

Top