how4a0rdlvnicawiy how4a0rdlvnicawiy
  • 21-02-2017
  • Computers and Technology
contestada

If the vlookup function cannot find the lookup value, the _________ error value is displayed in the cell.

Respuesta :

MissPhiladelphia
MissPhiladelphia MissPhiladelphia
  • 01-03-2017
The choices for this are:

a. #VALUE
b. #N/A
 c. #ERROR 
d. #NULL 

I believe the correct answer is option B. If the vlookup function cannot find the lookup value, the #N/A error value is displayed in the cell. It means not available. Hope this helps. Have a nice day.
Answer Link

Otras preguntas

Do I write the equation y=mx+b
2x + 5y = 0 x - 5y = -15
9+(3b + 8)=(3b + 8)+9
a state of great understanding and freedom is called what?
what is cultural diffusion and how did the silk road promote cultural diffusion
Which ordered pairs are solutions to the equation? y = 3x – 4 A. (11, 5) and (2, 2) B. (5, 11) and (3, 2) C. (5, 11) and (2, 3) D. (5, 11) a
why is the pyramids 30 feet shorter than they was when the were built
what is considered an Important Roman contribution to American government?
What is the process by which gases in the atmosphere absorb and re-radiate heat?
Susan rides her bicycle 5 miles 2\5 of an hour. At this rate, how many miles could she ride in 2hours