Forum Discussion
Solved
Index & Match formula not working on multiple column
https://onedrive.live.com/personal/8419718c3ad8f98c/_layouts/15/Doc.aspx?resid=8419718C3AD8F98C!s94600d3fa0044d418fefd1508e44c0e2&cid=8419718C3AD8F98C&migratedtospo=true&app=Excel Hi Folks, I...
You might use
=IFERROR(IFERROR(INDEX('RAW - reference '!$A$2:$A$72,MATCH(A2,'RAW - reference '!$B$2:$B$72,0)), INDEX('RAW - reference '!$A$2:$A$72,MATCH(A2,'RAW - reference '!$D$2:$D$72,0))),"")
If you have a recent version of Excel, you can also use
=XLOOKUP(A2,'RAW - reference '!$B$2:$B$72,'RAW - reference '!$A$2:$A$72,XLOOKUP(A2,'RAW - reference '!$D$2:$D$72,'RAW - reference '!$A$2:$A$72,""))
Perhaps you mean
=INDEX('RAW - reference '!$A:$A,
IFNA(
MATCH( A2,'RAW - reference '!$B:$B),
MATCH( A2,'RAW - reference '!$D:$D,0))
)
Thanks, but it is not desired outcome, even in the attached the result is not intact