Counter number output

**Tommy** · 05-01-2009, 05:47 PM

Please see attached

I have a time series with month beginning and end date and accompanying counter - Rows 1-3.

The range Choice is a dropdown list which the user can edit.

Based on this user date I want to return the counter output. eg for first date, 01 May 05, the counter return value would be 1.

Any help would be greatly appreciated.

Thanks

**oldchippy** · 05-01-2009, 06:09 PM

Hi,

First of all you need to format the cells in A9:A27 to exactly the same format as the dates in row 1 - at the moment they are not the same, then use

=HLOOKUP(A9,$A$1:$DP$3,3) drag downwards