Thanks sam, The formula is just rightthanks again
On Jan 14, 12:47 am, Sam Mathai Chacko wrote:
> Here's a simplified formula using named ranges
>
> =INDEX($D$4:$O$4,MATCH(MIN(TimeArray),TimeArray,0)),
>
> where TimeArray = =Sheet1!$R4-(Sheet1!$R4>=DateRow)*(DateRow),
> where DateRow =
> =OFF
Here's a simplified formula using named ranges
=INDEX($D$4:$O$4,MATCH(MIN(TimeArray),TimeArray,0)),
where TimeArray = =Sheet1!$R4-(Sheet1!$R4>=DateRow)*(DateRow),
where DateRow =
=OFFSET(Sheet1!$D$4:$O$4,MATCH(Sheet1!$Q4,Sheet1!$C$5:$C$27,0),0,1)
If you want a formula without a named range, you
Try this :
=INDEX(C4:N4,MATCH(Q3,INDIRECT("C" & MATCH(P3,$B$4:$B$28,0)+4
&":o"&MATCH(P3,$B$4:$B$28,0)+4),1))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: Jan/Fri/2012 03:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$