Get instant live expert help on vlookup if then
“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 an "if" statement that runs 2 conditional tests first on 2 different cells to determine if they are greater than 0, and then runs a vlookup, if the vlookup is false, then it returns a fixed number, if it is true then it performs the vlookup IF((AND(I12>0,I18>0)),(VLOOKUP(H6,Sheet2!A:B,2,false))), "10%", ((VLOOKUP(H6,Sheet2!A:B,2,TRUE)
Solved by G. Y. in 27 mins
need help to create formula if cell = yes then do vlookup if = no output 0
Solved by V. Q. in 16 mins
I need help trying to use an if then statement while using a vlookup
Solved by C. C. in 19 mins
if cell b3 contains "yes" then vlookup and insert values in to cell c3
Solved by S. Q. in 12 mins
need help on a vlookup forrmula. trying to look up text in a table and if not there then return "inactive, if there then return "active"
Solved by G. F. in 27 mins