Forum Discussion
IFS AND Function
Hey so I'm trying to create a column where depending on the amount of points a column would display Level 1, Level 2, Level 3 The point are distributed Level 1 (0 - 219) Level 2 (220 - 339) L...
=LOOKUP(C2,{0,220,340},{"Level 1","Level 2","Level 3"})
Or create a lookup table:
and use =VLOOKUP(C2,$J$2:$K$4,2)
Hey ive tried using the lookup table but it gives an error message. maybe cause it needs to be within the ranges and not just a match?
The value in J4 in the screenshot should have been 340 instead of 240, but the formula should work.
See the attached sample workbook.