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