Results 1 to 10 of 10

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

Threaded View

  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.

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