IF ERROR, INDEX MATCH

[mychi11]

I would like to index match cell B12,C12 and D12. is it possible to write a index match. I am able to match two of them. not sure how to add the third one.
=IFERROR(INDEX('CY NO'!$AZ$2:$AZ$5000,MATCH(A!$B$12,'CY NO'!$A$2:$A$5000,0)),IFERROR(INDEX('CY NO'!$AZ$2:$AZ$5000,MATCH(A!$C$12,'CY NO'!$A$2:$A$5000,0)),""))

 

[Zot]

See if this help

Excel INDEX MATCH with multiple criteria - formula examples

The tutorial shows how to do multiple criteria vlookup with INDEX and MATCH in Excel. Formula examples are available for download.

www.ablebits.com

 

[Fluff]

Are you trying to match all 3 values on a single row, or if B12 doesn't exists look for C12 & if that doesn't exist look for D12?

 

[Rahul1987]

I would like to index match cell B12,C12 and D12. is it possible to write a index match. I am able to match two of them. not sure how to add the third one.
=IFERROR(INDEX('CY NO'!$AZ$2:$AZ$5000,MATCH(A!$B$12,'CY NO'!$A$2:$A$5000,0)),IFERROR(INDEX('CY NO'!$AZ$2:$AZ$5000,MATCH(A!$C$12,'CY NO'!$A$2:$A$5000,0)),""))

Hi Mychi11

are you trying to obtain?

Index - Match.xlsx
	A	B	C	D	E	F	G	H	I
1	Grade	Color	Score	Price
2	ABC	Black	7	1.29				Grade	ABC
3	BCD	White	8	1.27				Color	Black
4	DFT	Red	4	1.22				Gauge	7
5								Price	1.29
Sheet1

Cell Formulas
Range	Formula
I5	I5	=INDEX(D2:D4,MATCH(1,INDEX(($B2:$B4=I3)*($C2:$C4=I4)*($A2:$A4=I2),0),0))
Press CTRL+SHIFT+ENTER to enter array formulas.