medium10 pts · first answer countsexcelxlookupdynamic-arrays

One XLOOKUP, three columns back

In Microsoft 365, what does this formula return?

A.Only the column B value for the matchB.The sum of columns B to D for the matchC.The B, C and D values for the match, spilled acrossD.A #VALUE! error, as the return range is wider than one column

Discussion 0

Join free to post in the discussion.

One XLOOKUP, three columns back

Discussion 0

Related questions