Home / Microsoft Excel / Question
MCQ
Which function returns a match using both vertical and horizontal lookup?
Microsoft Excel
A XLOOKUP
B VLOOKUP
C HLOOKUP
D INDEX
Explanation

XLOOKUP works in any direction without limits.

Related MCQs

Which function counts cells that meet a specified condition?
Microsoft Excel View
Which shortcut fills the selection down?
Microsoft Excel View
What is a circular reference in Excel?
Microsoft Excel View
What does a small red triangle in a cell mean?
Microsoft Excel View
Which function removes extra spaces from text?
Microsoft Excel View
Which function extracts characters from the right of text?
Microsoft Excel View