Forum Discussion
Index & Match formula not working on multiple column
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,""))
The link doesn't work - it requires a login.
HansVogelaar- I have verified the link is with general edit access with whomever having link.
Kindly attached the file, Please support for redressingYou 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 - Marvellous both are working , Thanks for this multi solve!
=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))),"")
=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,""))
