Get instant live expert help on How do I nested if vlookup
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a formula that will show where the salary falls on a specific range depending on the grade level. Like a nested vlookup and nested if.
Solved by I. B. in 11 mins
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
Can I use a if statement with vlookup? EX: If I do a search for a certain date with Vlookup, can I use a nested IF statement to check Vlookup for a match , then if there is a match fill several cells in that row with data from another cell? If so How
Solved by E. F. in 18 mins
Help with complicated vlookup (nested?) which will need to contain several different criteria.
Solved by E. Y. in 18 mins
In cell H7, create a nested if formula that will give the same results as the previous vlookup formula. Copy and paste the formula down the rest of the database.
Solved by E. E. in 27 mins