I need to match two column, if one number in a column number falls in a range within the 2nd column. The result is on track or off track.
Condition: (Column A: Age, ColumnB: Rank1-8)
Under Age 30, Rank 1-2 ontrack
Over Age 30, Rank 1-2 off track
Between Age 31-37, Rank 3-8 On Track
Between Age 38-45, Rank 5-8 On Track
Above 45, Rank below Rank 8 Off Track
Solved by F. Q. in 15 mins