Forum Discussion
What's my Best way to return a data value - Xlookup or Index/Match ?
What's my Best way to return a data value - Hello what's my best way to return a value based on multiple criteria? X lookup or Index/Match ? I have the sample data sheets below I need...
In R3:
=IFERROR(INDEX('[Sample data 1 lookup -.xlsx]Sheet1'!$H$2:$H$100000, XMATCH(1, ('[Sample data 1 lookup -.xlsx]Sheet1'!$D$2:$D$100000=D3)*('[Sample data 1 lookup -.xlsx]Sheet1'!$E$2:$E$100000=G3))), "")
or
=XLOOKUP(D3&"|"&G3, '[Sample data 1 lookup -.xlsx]Sheet1'!$D$2:$D$100000&"|"&'[Sample data 1 lookup -.xlsx]Sheet1'!$E$2:$E$100000, '[Sample data 1 lookup -.xlsx]Sheet1'!$H$2:$H$100000, "")
Fill down.