Vlookup to get data from a raneg within a single cell

Joined
May 11, 2016
Messages
2
Reaction score
0
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..

upload_2016-5-11_14-11-55.png
 
Joined
May 11, 2016
Messages
2
Reaction score
0
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
 

Attachments

  • Capture.PNG
    Capture.PNG
    20.6 KB · Views: 448
Joined
Aug 3, 2011
Messages
70
Reaction score
6
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:

Excel example.jpg


Hope that helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top