E
edwardpestian
I have the formula below, which takes the date from a cell(G8) and finds
the corresponding data in another worksheet(Data!). This formula is
working. But for some reason I can't get a second formula to look up
the data one cell to the right.
=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3:$CT$3,0)))
Any suggestions?
Regards,
EP
the corresponding data in another worksheet(Data!). This formula is
working. But for some reason I can't get a second formula to look up
the data one cell to the right.
=IF(Date=0,"",OFFSET(Data!$E$5,ROW(A1)+100,MATCH(G8,Data!$F$3:$CT$3,0)))
Any suggestions?
Regards,
EP