Search dates

W

WELSH_EXCEL

Hi,

I am new to this forum so apologies if there are any ground rules I
have missed.

I have a spreadsheet with dates and percentage. I want to be able to
search the data to retrieve a percentage.

For example, if I want to know what result was valid on 16 March, the
answer would be 60.0% as the latest result up to this date was 60.0% on
4 March 09.

I would like to be able to put any date in a cell and in the next cell
the most recent result for that date will appear.

I hope this makes sense.

I have attached a sample screenshot of the spreadsheet which may make
more sense!

Thanks,

Nick


+-------------------------------------------------------------------+
|Filename: screenshot.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=130|
+-------------------------------------------------------------------+
 

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

frustraded with conditional values return in a range of dates 1
Countif with dates 1
Returning a value from a range 1
Need help with average/lookup formula 2
If Formula and Dates 4
Search a range for instances of a text string, return neighboring cell values each ti 2
Date Range Formular 5
How do I count the number of blank cells 0

Top