I tried using a vlookup with 'approximate match' but it isn't quite giving me what I want.
I have the following lookup table
10 LOW
15 MID
30 HIGH
If I have data of the following - with the standard Vlookup with TRUE in column C giving me the following results:
JOHN 8 #n/a
MIKE 28 MID
I want to see what group they fall in? But I am really looking for anything that falls between 8-12 to be LOW, 13-18 MID, and 18 + HIGH. How do I build the lookup table and what formula do I use to give me my desired results? THANKS!!!
Bookmarks