Vlookup to get data from a raneg within a single cell

[TryllZ]

Hi,

I have this table that I want to get data from using Vlookup, but for some reason its not workingl, my value is $2608 its suppose to shoe me Average but its showing me Excellent, any guesses..

 

[Becky]

Welcome to the forum!

What is your formula?

 

[TryllZ]

With this code this (=VLOOKUP(D24,B$31:C$34,2,TRUE)) is what I'm getting:

But I was looking for more like multiple range within a single cell

 

[Becky]

Sorry for the late reply! The problem lies with the banding I think. VLOOKUP expects a list of values with corresponding outcomes, which would require you to list all possible numbers (ie over 20,000!) with their corresponding values.

You can achieve a good result with an IF function, in conjunction with AND functions, as shown here:

Hope that helps!

 

[XLPadawan]

I prefer INDEX/MATCH over VLOOKUP. For me, it's more intuitive and versatile.