Q. What is the purpose of the XLOOKUP function in Excel?

A
Sorts data
B
Replaces VLOOKUP with more flexibility
C
Counts cells
D
Merges tables
Solution:

XLOOKUP() is a modern replacement for VLOOKUP, offering more flexible lookup and return options.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!