# Get instant live expert help on if error vlookup

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to create a formula using nested IF functions and VLOOKUP functions. The following formula returns an error message. Please show me the error in my syntax - =IF(B16="Destroy",VLOOKUP(B14,Dept_Returns,2,FALSE),IF(B16="Return to Mfg",VLOOKUP(B14,Dept_Returns,3,FALSE),IF(B16="Repack",VLOOKUP(B14,Dept_Returns,4,FALSE),IF(B16="Restock",VLOOKUP(B14,Dept_Returns,5,FALSE),"None"))))
Solved by K. S. in 19 mins
=IF(D8="SDC",VLOOKUP(D8,\$G\$3:\$L\$5,2,0)+1)*\$G8, IF(D8="TP",VLOOKUP(D8,\$G\$3:\$L\$5,2,0)+1)*\$G8, IF(D8="ISCI",VLOOKUP(D8,\$G\$3:\$L\$5,2,FALSE)+1)*G8 I get a value error. When I use one "IF" statement it works but when I add two additional statement error happens.
Solved by I. J. in 30 mins
I am trying to perform a simple vlookup, but keep getting an error. When I try the same simple vlookup I don't get an error. How do I know if my excel isn't corrupt?
Solved by Z. U. in 28 mins