What is wrong with the formula =VLOOKUP(A7,A1:C7,3) in cell B7? Check all that you believe is incorrect with the formula.
A. The range for the lookup table is not correct
B. It is performing an approximate lookup
C. Cell A7 must be anchored and should be $A$7
D. The column value of 3 is out of range and must be 2
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
(Save $1 )
One time Pay
(Save $5 )
Billed Monthly
*First month only
You can see the logs in the Dashboard.
