You can use a _____ function to return a value from a table that is based on an approximate match lookup.
A)VLOOKUP
B)VAVERAGE
C)VMATCH
D)VAPPROXIMATE

Question

Quizplus · Accepted Answer

The VLOOKUP function is used to return a value from a table that is based on an approximate match lookup. It is commonly used in Excel for tasks such as finding a price or product code based on a search term or ID number. The VAVERAGE function calculates the average of a range of numbers, the VMATCH function is used to find the position of a specified value in a range of cells, and the VAPPROXIMATE function does not exist in Excel.

You Can Use a _____ Function to Return a Value