Excel Lookup Functions and Best Practices

This video tutorial explains the differences between the VLOOKUP and LOOKUP functions in Excel. VLOOKUP is used for retrieving data from the right side of a reference column, while LOOKUP can retrieve data from both sides. The tutorial demonstrates how to use these functions with examples, highlighting the limitations of VLOOKUP when dealing with left-side data and the importance of ordered data for the LOOKUP function. Recommendations for using these functions effectively are also provided.

What is the primary difference between VLOOKUP and LOOKUP functions?

• VLOOKUP can look up data on both sides of the reference column.

• VLOOKUP can only look up data on the right side, while LOOKUP can look up on both sides.

• LOOKUP can only look up data on the left side of the reference column.

• LOOKUP can only look up data on the right side of the reference column.

When using VLOOKUP, why is it important to select the correct table array?

• To ensure the function can look up data on the left side.

• To prevent errors and ensure the correct data is retrieved.

• To enable the function to look up multiple columns at once.

• To allow the function to work with unordered data.

What happens if you try to use VLOOKUP to find data to the left of the reference column?

• It will automatically switch to using the LOOKUP function.

• It will return an error or incorrect data.

• It will only work if the data is numeric.

• It will work if the data is in ascending order.

Which function should you use to look up data to the left of the reference column?

• VLOOKUP

• HLOOKUP

• INDEX

• LOOKUP

Why is it important for ID numbers to be in ascending order when using the LOOKUP function?

• To prevent the function from skipping rows.

• To ensure the function retrieves the correct data.

• To enable the function to work with text data.

• To allow the function to look up data on both sides.

What is a potential issue with the LOOKUP function in Excel 2016?

• It cannot look up data on the right side.

• It requires data to be in descending order.

• It may not work if ID numbers are not in order.

• It only works with numeric data.

How can you ensure the LOOKUP function works correctly with unordered data?

• Use the VLOOKUP function instead.

• Sort the data in ascending order.

• Convert all data to text format.

• Use a different reference column.

What should you do if you need to look up information on the right of your reference column?

• Use the HLOOKUP function.

• Use the VLOOKUP function.

• Use the LOOKUP function.

• Sort the data in descending order.

Which function is recommended for looking up data to the left of a reference column?

• LOOKUP

• VLOOKUP

• HLOOKUP

• MATCH

What is a key recommendation when using the LOOKUP function?

• Always use it with the VLOOKUP function.

• Avoid using it for large datasets.

• Use it only for numeric data.

• Ensure data is in ascending order.