hard20 pts · first answer countsexcelxlookup

XLOOKUP with a partial name

A user types "Reliance*" in F2 to find the first company whose name starts with Reliance. Which XLOOKUP works?

A.=XLOOKUP(F2,A:A,B:B,"None",0)B.=XLOOKUP(F2,A:A,B:B,"None",1)C.=XLOOKUP(F2,A:A,B:B,"None",-1)D.=XLOOKUP(F2,A:A,B:B,"None",2)

Discussion 0

Join free to post in the discussion.