Hi
I've got this formula which works correctly but is a bit long winded and has a few nested IF statements;
=IF(G7="eombh",INDEX(E2:E22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),IF(G7="eom",INDEX(D2:D22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),(INDEX(C2:C22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)))))
G2= system
G3 = Day
G7="eombh etc"
<tbody>
</tbody>
can anyone help with simplify it?
many thanks
I've got this formula which works correctly but is a bit long winded and has a few nested IF statements;
=IF(G7="eombh",INDEX(E2:E22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),IF(G7="eom",INDEX(D2:D22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)),(INDEX(C2:C22,MATCH(1,(G2=A2:A22)*(G3=B2:B22),0)))))
G2= system
G3 = Day
G7="eombh etc"
System A | Monday | 08:00 | 08:15 | 09:00 |
System A | Tuesday | 08:30 | 08:45 | 09:15 |
System B | Monday | 07:00 | 07:15 | 08:15 |
System B | Tuesday | 07:30 | 07:45 | 08:50 |
<tbody>
</tbody>
can anyone help with simplify it?
many thanks