Solved

If the VLOOKUP Function Cannot Find a Match in the Lookup

Question 416

Multiple Choice

If the VLOOKUP function cannot find a match in the lookup table, what does it return?

A) "Match not found" message
B) #N/A error value
C) FALSE
D) #NAME error value

Related Questions

Q27: To paste a data range so that

Q28: Your worksheet appears with a reduced view

Q411: Which of the following is an acceptable

Q412: To locate duplicate values in a selected

Q413: When you set up worksheet protection, you

Q415: The Percent style formats numbers as percentages

Q417: When Kai right-clicks a sheet tab in

Q418: You can edit several worksheets at the

Q420: The CUMIPMT function has the syntax CUMIPMT(Rate,

Q421: To create a PivotTable layout, you can