Get instant live Excel expert help and learn how to use an IF function with a 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

vlookup from sheet1 column L to sheet2 column A use match to pull ID in column B from sheet 2 to Column Q in Sheet1 NOTE: If N/A exist in Sheet1 column L skip and do not change the ID associated in column Q (These are highlighted in yellow as NEUTRAL)
Solved by V. W. in 15 mins
I want to run a formula where: if i vlookup based on cell1 and the returned value contains text found in cell2, then another vlookup will be run
Solved by C. W. in 25 mins
Hi guys, I have a big database that I want to connect to another database. I want to get a value for from one of the databases into the first, but only if the name and the builder of the particular vessel is the same. I am trying with vlookup, index and match, but I can not get it to work. Can you help me?
Solved by Z. J. in 17 mins
match Sheet1 Column A to Sheet2 Column A if they match then copy Sheet2 Column B to Sheet1 Column I vlookup
Solved by T. B. in 18 mins
Hello, I am trying to create a csv generator which will look up all the information from background speadsheets and bring it up in the necessary fields. I am not sure why but when I change the column index number (where the pricing info is), it does not want to work, can anyone help please? My formula is below: To look up Description =IF(LEN(E16)<1,IF(LEN(G16)<1,"",VLOOKUP(G16,MATCODE1,2,FALSE)),"") To look up Price =IF(LEN(G16)<1,IF(LEN(J16)<1,"",VLOOKUP(J16,MATCODE1,5,FALSE)),"")
Solved by I. D. in 27 mins
I have a list of cities in my column a. I have all my active keywords in column b. I would like to extract all the city names so I get the destination in column C. Is this possible with a quick fix? I have tried to use a Vlookup true function, to get the closest variant. But this did not work. I have also tried an "If" with a "Is.number" and "Find" inside. But could not get this to work either. I am looking forward to hear from you. Best regards
Solved by V. J. in 14 mins
1)Creating a cell that has dependent data validation from a category list 2) vlookup or if statement, that when a category and then a description has been selected from drop downs, a unit price will automatically appear
Solved by G. A. in 21 mins
How can I create a formula or vlookup if I want for example if someone types the letter A =1 B=2 etc?
Solved by F. Q. in 21 mins
in cell Q3 nest the existing VLOOKUP function in an IFERROR function. If the VLOOPUP function returns an error result, the text "invalid staff ID" should be displayed by the formula. Existing function is =VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE)
Solved by D. Y. in 20 mins
I want to use vlookup to find values and if there is an error i want it to return the exact value that is there. so instead of zero or blank or error, I want it to return what is in the cell if there is an error.
Solved by B. E. in 13 mins