Forum Discussion
Solved
Lookup Formula with multiple column
Hi There, I am trying to return data in a particular column but the lookup value could be in any of a number of columns and I am not sure the best way to pull this in. I have shown a snip with an exa...
= LET(
row, TOCOL(IF(totalling, rowNo, NA()), 3),
tot, TOCOL(totalling, 3),
XLOOKUP(GL, tot, row)
)
This 365 formula converts the 'Totalling' array to a single column omitting blanks. It uses broadcasting to do the same with RowNo. From there, it is a simple XLOOKUP.
thank you. I am not that familiar with 365 formula so think this is a bit advanced for me, but I appreciate your response