Data Lookup in Excel

What does the VLOOKUP function do in Excel?

• The VLOOKUP function looks up a value in a table and retrieves corresponding data from another column.

• The VLOOKUP function sorts data in a table.

• The VLOOKUP function calculates the sum of a column.

How do you specify the table_array range for the HLOOKUP function?

• Use a single cell reference like A1.

• Use a range reference like A1:D10 for the table array.

What is the purpose of the MATCH function in indexing?

• To find the position of a value in a range.

• To calculate the average of a range.

• To sort values in ascending order.

Can VLOOKUP search for values to the left of the lookup column?

• Yes, VLOOKUP can search for values to the left of the lookup column.

• VLOOKUP can search both left and right of the lookup column.

• No, VLOOKUP cannot search for values to the left of the lookup column.

What is the difference between VLOOKUP and HLOOKUP?

• VLOOKUP is for vertical lookups, while HLOOKUP is for horizontal lookups.

• VLOOKUP is used for searching in databases, while HLOOKUP is for spreadsheets.