Hi,
I have below table and what I need is to assign the right grp number when the condition is met.
The current formula is
=IF(OR(A2<=E2,A2>=F2),G2,
IF(OR(A2<=E3,A2>F3),G3,
IF(OR(A2<=E4,A2>=F4),G4,
IF(OR(A2<=E5,A2>=F5),G5,
IF(OR(A2<=E6,A2>=F6),G6,
IF(OR(A2<=E7,A2>=F7),G7...