Google Sheets Formulas: VLOOKUP and HLOOKUP

What is the primary purpose of the VLOOKUP function in Google Sheets?

• To extract data from horizontal tables

• To extract data from vertical tables

• To sort data in descending order

• To calculate the sum of a range

Why is it important to sort data in ascending order when using VLOOKUP or HLOOKUP?

• To prevent errors in the spreadsheet

• To ensure the functions return the correct data

• To increase the speed of calculations

• To make the table look organized

In the VLOOKUP function, what does the 'index' parameter specify?

• The search key to look for

• The range of data to search

• The column number to return data from

• The row number to search

How does the HLOOKUP function differ from the VLOOKUP function?

• HLOOKUP is faster than VLOOKUP

• HLOOKUP is used for numerical data, VLOOKUP for text

• HLOOKUP requires data to be in descending order

• HLOOKUP searches horizontally, VLOOKUP searches vertically

What happens if the search key is not found in the first row of the table when using HLOOKUP?

• The function returns a zero

• The function stops at the previous value in the table

• The function returns the last value in the row

• The function returns an error