INDEX MATCH FORMULA WITH MULTIPLE CRITERIA

[mdthekkath]

	SLAB
GRADE	10000	25000	50000	200000
G	10%	30%	50%	70%
G+PP	11%	31%	51%	71%
G+W	12%	32%	52%	72%
PP	13%	33%	53%	73%
W	14%	34%	54%	74%
G+Q	15%	35%	55%	75%
W+Q	16%	36%	56%	76%
W+Q+G	17%	37%	57%	77%
W+Q+PP	18%	38%	58%	78%
PP+W	19%	39%	59%	79%
PP+Q	20%	40%	60%	80%
PP+G+Q	21%	41%	61%	81%
Need to have the appropriate % for respective grade depending upon the slab to be filled in separate cell

 

[arthurbr]

Could you pleae add your XL version to your profile
XLOOKUP will do if you have the right XL version

 

[maabadi]

Welcome to MrExcel Message Board.
Try this:

Book1
	A	B	C	D	E	F	G	H
1	GRADE	10000	25000	50000	200000			10000
2	G	10%	30%	50%	70%		G	0.1
3	G+PP	11%	31%	51%	71%		PP	0.13
4	G+W	12%	32%	52%	72%		G+Q	0.15
5	PP	13%	33%	53%	73%
6	W	14%	34%	54%	74%
7	G+Q	15%	35%	55%	75%
8	W+Q	16%	36%	56%	76%
9	W+Q+G	17%	37%	57%	77%
10	W+Q+PP	18%	38%	58%	78%
11	PP+W	19%	39%	59%	79%
12	PP+Q	20%	40%	60%	80%
13	PP+G+Q	21%	41%	61%	81%
Sheet1

Cell Formulas
Range	Formula
H2:H4	H2	=INDEX($B$2:$E$13,MATCH(G2,$A$2:$A$13,0),MATCH(H$1,$B$1:$E$1,0))