Results 1 to 6 of 6

Fine value in chart based off two critera

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2017
    Location
    Georgia, US
    MS-Off Ver
    Office 2016 ProPlus
    Posts
    3

    Fine value in chart based off two critera

    First, thanks for the help. I hope to explain this properly. I'm also open to VBA/Macro/Add-Ins if that is a possible solution.

    Basic language:
    I have a workbook for a character database. Sheet 1 contains summary of a Character information (Race, XP, Level, Lives). I am currently keeping this up-to-date manually. I'd like this populate based off values in other sheets. Sheet 2, for example, contains Race information. Race, Level, XP, Body, Live increase. I want to find what level someone should be based off comparing sheet 1 to 2.

    Excel example:

    Sheet 1
    	A	B	C	D	E
    -----------------------------------------------------
    Row1	|  Name		Race	XP	Level	Lives
    Row2	|  Ansley	Human	55.72
    Row3	|  Bert		Human	19.74	
    Row4	|  Carter	Elf	42.87

    Sheet 2
    	A	B	C	D	E	F
    -----------------------------------------------------------
    Row1	|  Race		XP	Level	Body	Lives
    Row2	|  Human	0	1	5	3
    Row3	|  Human	16	2	10	
    Row4	|  Human	25	3	15	1
    Row5	|  Human	37	4	20	
    Row6	|  Human	50	5	25	
    Row7	|  Human	64	6	30	1
    Row8	|  Elf		0	1	4	3
    Row9	|  Elf		17	2	8		
    Row10	|  Elf		27	3	12	1
    Row11	|  Elf		39	4	16	
    Row12	|  Elf		52	5	20	
    Row13	|  Elf		66	6	24	1
    The expected results should return:
    Ansley - Level 5 (Row 6, Column C)
    Bert - Level 2
    Carter - Level 4

    I can add another cell to have XP Min and XP Max if need be, but I could not get my logic to work around that either.
    Last edited by thunderchld; 03-01-2017 at 06:45 PM. Reason: Chart was poorly formatted

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Charts not recognizing label column. Chart values appear to be fine.
    By chad.botbyl in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-13-2016, 05:26 AM
  2. [SOLVED] Help with modifying VBA Macro - Works fine but needs fine tuning !
    By stefan27 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2015, 10:27 AM
  3. Ranking Based on Critera
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-21-2014, 06:48 AM
  4. [SOLVED] Add total values based on within range based on critera
    By johnny_p in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2013, 06:50 AM
  5. Average based on 2 critera
    By k8bug79 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-01-2013, 10:55 AM
  6. [SOLVED] Return a Value Based on 3 Critera
    By mvp23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2006, 07:10 PM
  7. [SOLVED] Moving data Based on critera.
    By RQtech in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2006, 03:00 PM

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