# Extracting Data From Charts Using Ranges (V-Lookup W/ Ranges?)

1. ## Extracting Data From Charts Using Ranges (V-Lookup W/ Ranges?)

Hello,

A rather simple problem I'm looking for a solution with.

I'm making some spreadsheets for online gaming, and basically, x amount of exp = x level. What i want to do is, have the amount of exp I have written down, and extract from a table what level I would be with that amount. Normally I wouldn't have an issue, except for the fact that i need to be able to search within a range.

The example I have provided I have exp listed as "50". In the column next to it, I want to be able to automatically assign the level I'd be, using the chart to the right. Anywhere between 20 and 79 exp would be level 2, so I would want it to extract the level "2" from the chart using a range.

Hopefully I explained this clear enough lol.

2. ## Re: Extracting Data From Charts Using Ranges

Either I'm missing something, or you've uploaded the wrong file?

3. ## Re: Extracting Data From Charts Using Ranges

Sorry I did, I had same file name uploaded from years ago on here, I thought it was my desktop sorry lol, Uploading proper file now.

4. ## Re: Extracting Data From Charts Using Ranges

Try using this:

=MIN(IF(H4:H8-A3>=0,G4:G8)) and confirm with Ctrl+Shift+Enter

5. ## Re: Extracting Data From Charts Using Ranges

Getting #value with that. From looks of it, that would work if the exact 50 value was on the chart, since none of the exp values minus 50 would = 0. I need something that will search within a range on that chart.

6. ## Re: Extracting Data From Charts Using Ranges (V-Lookup w/ Ranges?)

I'm basically assuming I'd be using a manipulation of V-Lookup, but I'm not sure how to set Vlookup to find a value within a range.

7. ## Re: Extracting Data From Charts Using Ranges

Did you remember to press Ctrl+Shift+Enter instead of just Enter when you put in the formula?

I've attached a workbook where it should work:

8. ## Re: Extracting Data From Charts Using Ranges

Originally Posted by Kolin
Getting #value with that. From looks of it, that would work if the exact 50 value was on the chart, since none of the exp values minus 50 would = 0. I need something that will search within a range on that chart.
The formula should work no matter what value is in A3.

9. ## Re: Extracting Data From Charts Using Ranges (V-Lookup W/ Ranges?)

Ah sorry I didn't realize when to do Control + Shift + Enter, works tyvm :D

10. ## Re: Extracting Data From Charts Using Ranges (V-Lookup W/ Ranges?)

Not a problem.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1