easy5 pts · first answer countsexcelxlookup

Friendly message when an ID is missing

Which formula shows "Not listed" instead of #N/A when the ID in F2 is not found?

A.=XLOOKUP(F2,A2:A400,C2:C400,0,"Not listed")B.=XLOOKUP("Not listed",F2,A2:A400,C2:C400)C.=XLOOKUP(F2,A2:A400,"Not listed",C2:C400)D.=XLOOKUP(F2,A2:A400,C2:C400,"Not listed")

Discussion 0

Join free to post in the discussion.

Friendly message when an ID is missing

Discussion 0

Related questions