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|
+----------------------------------------------------------------+
 
Back
Top