Cider_Lad
New Member
- Joined
- Jun 15, 2020
- Messages
- 3
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi All,
I have a lookup table in excel like the below:
And a data set like the below what I want to do is have a formula return the correct bracket letter for the value range and client letter.
Can anyone give me any help on how to achieve this?
Thanks.
I have a lookup table in excel like the below:
Client | Min value | max value | Bracket |
A | 0 | 100 | A |
A | 101 | 200 | B |
A | 201 | 300 | C |
B | 0 | 200 | A |
B | 201 | 300 | B |
C | 0 | 300 | A |
D | 0 | 250 | A |
And a data set like the below what I want to do is have a formula return the correct bracket letter for the value range and client letter.
Client | Value | Bracket | |
A | 456 | ||
B | 289 | ||
C | 200 |
Can anyone give me any help on how to achieve this?
Thanks.