Find A Date

**SamuelT** · 12-10-2008, 08:13 AM

Hi all,

Wonder if anyone can help with this one. I've been trying various INDEX/MATCH combinations, but currently no joy.

On one sheet ('Overview') I have a row with a number of dates in the cells (B4:H4). Each column has a project stage title (B3:H3).

On another ('Detail') I want Excel to look at a date and find which project stage this is part of. For example, in 'Detail' I might have the date 1/12/2008. On the 'Overview' page this date might fall under the 'Send Drawings To Contractor' stage, even though this stage begins on 15/11/2008. and the next stage begins 10/12/2008.

I've attached an example of the sheet I'm putting together - hope it makes things clearer.

TIA,

SamuelT

**Steve R** · 12-10-2008, 08:58 AM

I hope this works! See attached file.

**daddylonglegs** · 12-10-2008, 09:18 AM

Steve's suggestion may be all you require but if you need to also match "Site 1", i.e. because you can't guarantee the row order, you could use this version

=LOOKUP(B4,INDEX(Overview!B$4:H$13,MATCH(A4,Overview!A$4:A$13,0),0),Overview!B$3:H$3)