lookup a date from an array of date ranges if conditions are met

  • Thread starter Thread starter nscanceran
  • Start date Start date
N

nscanceran

Please help...i need to lookup up a value on a specific date range.
for example:



column A: column b
(from
9/01/2003
 
Sounds like autofilter could be something, select the data (should have
headers), do data>filter>autofilter,
filter on the date column using custom and gate than or equal to and put
09/01/03 as a criteria
 
Thanks Peo.
However, what I actually need is to lookup and return a data using the
table as reference. Please refer to the attached excel file for the
actual data. Hope you can help me. Thanks very much.


Regards!


+----------------------------------------------------------------+
| Attachment filename: example.zip |
|Download attachment: http://www.excelforum.com/attachment.php?postid=353011|
+----------------------------------------------------------------+
 
You must log in or register to reply here.

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

conditional formula question with multiple criteria 2
Two Condition Vlookup 1
Lookup date range row A and count if leave in same column on row B 6
"If" statement with Vlookup 2
Sumif function with a date range condition statement 4
Date between date range 1
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
complex color fill conditions- if statements or complex formula? 1

Back
Top