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,""))
HansVogelaar- I have added the link with edit access, whomever have the link only, but don't know why it is asking for login.
Kindly adding the file as a attachment. Please look into it and support.