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.

Hi
Welcome to the board

Try in Sheet1!D2:

=LOOKUP(C2,Sheet2!$B$2:$B$13/(Sheet2!$A$2:$A$13=B2),Sheet2!$C$2:$C$13)

Copy down.

Remark:
This solution assumes the setup of your table in Sheet2, namely XP in ascending order for each race

Assuming your answer lies in D2, try the following ARRAY formula entered by pressing CTRL+SHIFT+ENTER:

D2: =INDEX(Sheet2!$C$2:$C$13,MATCH($C2,IF(Sheet2!$A$2:$A$13=$B2,Sheet2!$B$2:$B$13),1))

Data does not need to be in any particular order.