Searching for first and last in a table to chart (gantt)
In article ,
Domenic wrote:
Last:
=LOOKUP(9.99999999999999E+307,IF(INDEX(G3:K5,MATCH ("Yt",A3:A5,0),0)0,G2:
K2))
...confirmed with CONTROL+SHIFT+ENTER
Can be shortened...
=LOOKUP(2,1/(INDEX(G3:K5,MATCH("Yt",A3:A5,0),0)0),G2:K2)
....confirmed with just ENTER.
Hope this helps!
|