The ____ function is used when a table direction is vertical.
A) HLOOKUP
B) ZLOOKUP
C) VLOOKUP
D) MLOOKUP

Name: The ____ function is used when a table direction is vertical. A) HLOOKUP B) ZLOOKUP C) VLOOKUP D) MLOOKUP
Brand: Quizplus
Rating: 4.9 (34 reviews)

Question

Quizplus · Accepted Answer

VLOOKUP stands for Vertical Lookup and is specifically designed for tables that have a vertical structure, with data arranged in columns. HLOOKUP is designed for tables with a horizontal structure, with data arranged in rows. ZLOOKUP and MLOOKUP are not valid functions in Excel.

The ____ Function Is Used When a Table Direction Is