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

what are all the zeros of function g(x) = (x + 2)(x − 2)(x − 3),
1) (2x - 3)2-(3x - 2)2. Factorize​
A man drove 14 mi directly east from his home, made a left turn at an intersection, and then traveled 5 mi north to his place of work. If a road was made direct
Write a function rule using function notation that will transform a geometric figure by rotating it 270 degrees clockwise. a f(x, y)=(-y, x) b f(x, y)=(y, x) c
Which equation below represents the equivalent exponential equation for the equation of log6 256=x?(in picture)
as a result of the law of conversation of mass a balanced chemical equation must ​
avancemos workbook answers Page 8
When your scalpel gets dull or is broken, it should be disposed of by a. Placing in the broken glass/sharps container b. Thrown in the trash c. Kept in your dis
optionsradiationconvectionconductionevaporation​
aggregate demand is everything produced while simple demand is one good. what statement reflects that aggregate demand? A. calculating average price level B. ca