You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
-You implement the VLOOKUP formula at your colleague's suggestion,but you get the #VALUE! error as the result of the formula.Which of the following is likely true?
A)You might have entered a table name for the table_array value instead of the cell reference of the lookup table.
B)You might have indicated that the compare values are a range of values instead of an exact match.
C)You might have entered a number for the col_index_num instead of a letter.
D)You might have entered a letter for the col_index_num instead of a number.

Question

Quizplus · Accepted Answer

The #VALUE! error often occurs when the col_index_num argument in the VLOOKUP function is a letter instead of a number. The col_index_num argument should be the number of the column containing the return value, not the actual column letter.

You Have Been Using a Variety of Nested IF Functions