The ________ error will appear if VLOOKUP attempts to reference linked table data in another workbook that is NOT open

A) #N/A!
B) #ERROR!
C) #VALUE!
D) #REF!

Answer: D

Computer Science & Information Technology

You might also like to view...

When the Cascade options are enabled, a user can only update and delete records automatically by making changes to the table on the ________ side of the one-to-many relationship

Fill in the blank(s) with correct word

Computer Science & Information Technology

If a user attempts to enter a value in a Combo Box that is not present in the table, and the Limit to List property is enabled, Access will generate a(n) ________ message

Fill in the blank(s) with correct word

Computer Science & Information Technology