+ Reply to Thread
Results 1 to 10 of 10

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

  1. #1
    Registered User
    Join Date
    02-04-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2016
    Posts
    36

    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.
    Attached Files Attached Files
    Last edited by Kolin; 04-14-2012 at 05:37 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Extracting Data From Charts Using Ranges

    Either I'm missing something, or you've uploaded the wrong file?
    Sincerely
    Søren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Registered User
    Join Date
    02-04-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2016
    Posts
    36

    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.

    EDIT: Proper file uploaded

  4. #4
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    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. #5
    Registered User
    Join Date
    02-04-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2016
    Posts
    36

    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. #6
    Registered User
    Join Date
    02-04-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2016
    Posts
    36

    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. #7
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    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:
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Extracting Data From Charts Using Ranges

    Quote Originally Posted by Kolin View Post
    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. #9
    Registered User
    Join Date
    02-04-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2016
    Posts
    36

    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. #10
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

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

    Not a problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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