BigBeachBananas
Active Member
- Joined
- Jul 13, 2021
- Messages
- 450
- Office Version
- 365
- Platform
- Windows
- MacOS
I have age data and I want to group them according to the lookup on the right. What's the simplest way to do it?
GENLI_ASSUMED.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Data | Lookup Table | ||||||
2 | Age | Age Band | Min | Max | Issue Age Band | |||
3 | 1 | 0 | 20 | 0-20 | ||||
4 | 12 | 21 | 30 | 21-30 | ||||
5 | 25 | 31 | 40 | 31-40 | ||||
6 | 16 | 41 | 50 | 41-50 | ||||
7 | 70 | 51 | 60 | 51-60 | ||||
8 | 41 | 61 | 70 | 61-70 | ||||
9 | 70 | 70+ | ||||||
Sheet2 |