How to do an Index Match Formula with multiple criteria ? ( Having issues)

1
votes

sheet2 enter image description here

WorkSheet enter image description here

The formula isn't pulling any value in return

'=IFERROR((INDEX((Sheet2!$A:$K,MATCH(Worksheet!XFD5,Sheet2!$A:$A,0),MATCH(Worksheet!E2,Sheet2!$H$1:$K$1,0)),INDEX(Sheet2!$H:$K,MATCH(Worksheet!E2,Sheet2!$A:$A,0),MATCH(Worksheet!E2,Sheet2!$H$1:$K$1,0)))

Summary:

I'm attempting to pull the number for a specific color in Worksheet 1 (Row H) based on the criteria in Sheet2 in columns H:K.

1
excelvbaexcel-formulavlookup
Split it into sections like match() and check that result then does index() return a value using the result of match etc? Check each step logically. – Solar Mike

1 Answers

2
votes

You may use the following method to extract value based on your data, it work perfectly, simply adjust the range based on your sheet will do:

=INDEX(H:K,MATCH(M2,A:A,0),MATCH(P2,$H$1:$K$1,0))

enter image description here