easy5 pts · first answer countsexcellookups

Lookup on a repeated ID

A customer ID appears in 5 different order rows. =XLOOKUP(F2,A:A,D:D) returns only one amount. Which one?

A.The total of all five amountsB.The amount from the first matching rowC.The largest of the five amountsD.An error, since the lookup ID is repeated in the list

Discussion 0

Join free to post in the discussion.

Lookup on a repeated ID

Discussion 0

Related questions