Forum Discussion
Roshansa890
Apr 25, 2025Copper Contributor
Instead of XLOOKUP function what combination of function can be used ?
Can combination of match and index function help ?
PeterBartholomew1
Apr 27, 2025Silver Contributor
A good question might be 'Why don't you just use XLOOKUP?'
Something that INDEX/XMATCH will do that XLOOKUP is reluctant to do is return and array of arrays
= LET(
fieldNum, XMATCH(outputHeaders, TblHeaders),
recordNum, XMATCH(foreignKeys, primaryKeys),
INDEX(data, recordNum, fieldNum)
)