Get instant live Excel expert help figuring out why your VLOOKUP is not working
“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
Hello, I am trying to combine an IF and VLOOKUP formula. I am trying to build an invoice sheet and I want to make it so if there is no code in the Product code space then Product name, description and unit price will be blank.
After researching I found this =IF(ISNA(VLOOKUP(A20,Poducts,2,FALSE)),"",VLOOKUP(A20,Products,2,FALSE))
But it is not working as the N/A does not dissapear from the spaces with no codes.
In my workbook I have a sheet called clients, products and Invoice with the tables carrying the same names for referring Vlookup.
Any help is appreciated.
Solved by T. L. in 25 mins
Vlookup formula not working when combining with IF. If formula alone is not sufficient.
Solved by V. Q. in 13 mins
Need someone exlain vlookup in excel for dummies. Vlookup formula not working and cannot find out why!
Solved by E. H. in 11 mins
I need help in excel . Am using Vlookup but its not working
Solved by Z. H. in 25 mins
HI there, I need a hand with a vlookup that is not working properly
Solved by A. A. in 16 mins