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 addition, you may return data at once
=XLOOKUP(
$D$3:INDEX($D:$D, COUNTA($D:$D)+1) & "@" &
$G$3:INDEX($G:$G, COUNTA($D:$D)+1),
'[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,
"---" )