Forum Discussion
GregHastings
Aug 24, 2019Copper Contributor
Reverse HLookup?
Hi Folks; I am putting a level scheduling spreadsheet together, where I want to slide schedule hours left and right on the row. At the top are the dates. So I want to see where the first occurr...
SergeiBaklan
Aug 24, 2019Diamond Contributor
Hi Greg,
If that's something like this
formula for Start date
=INDEX($A$1:$L$1,0,
MATCH(1,INDEX(
ISNUMBER(INDEX($A$2:$L$5,MATCH($B7,$A$2:$A$5,0),0))*
(INDEX($A$2:$L$5,MATCH($B7,$A$2:$A$5,0),0)>0),
0),
0))
for End date
=LOOKUP(2,1/(INDEX($A$2:$L$5,MATCH($B7,$A$2:$A$5,0),0)>0),$A$1:$L$1)