easy5 pts · first answer countsexcellookupsxlookup

Writing a basic XLOOKUP

Employee IDs are in A2:A400 and names in C2:C400. Which formula returns the name for the ID in F2?

A.=XLOOKUP(A2:A400,F2,C2:C400)B.=XLOOKUP(F2,C2:C400,A2:A400)C.=XLOOKUP(F2,A2:C400,3)D.=XLOOKUP(F2,A2:A400,C2:C400)

Discussion 0

Join free to post in the discussion.