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

I'm using a simple IF formula that won't return the correct results because it's pulling from a cell that has a VLOOKUP formula in it. It's not recognizing it as a number.
Solved by E. F. in 23 mins
Hello I have an mlb spreadsheet that is in the works and I need help with doing a VLookUp. If the batter is facing a Left handed pitcher (If G2=L) I would like to pull data from Tab "Hitter stats Left" or if a batter is facing a Right handed pitcher (G2=R)... I would like it to pull data from tab "Hitter stats Right". Any help would be appreciated.
Solved by I. D. in 21 mins
I have a sheet with lots of IFERROR and VLOOKUP formulas. If I want to add two VLOOKUP formulas together, how do I create an IFERROR if no value is returned?
Solved by D. S. in 26 mins
need help to find out what is wrong with this formula IF(AND(B11="20-29",D11="VO2max",E11="FEMALE"),VLOOKUP(F11,$R$78:$T$82,3,TRUE),""
Solved by F. F. in 13 mins
How to get the last value froma sheet using vlookup if the same is occuring multiple times ?
Solved by A. W. in 28 mins
Hello- I am having an issue with vlookup. No matter what I do, it is returning the same result, regardless of the sku it is searching for- even if I copy and paste the sku into the sheet the exact same way it is typed in the sheet its searching.
Solved by V. Q. in 28 mins
Im doing VLookup and want to all the column in C (second spreadsheet - Copy of Period Summary) to go into Column AC - 1st spreadsheet with (Copy of Week 2014-15 36. ) And add column X to the result. Two problems with this, if there is nothing in Column X it throws up an N/A. And it seems to put in N/A randomly anyway, I havent looked into this properly, it could be that they are just not on the Second spreadsheet
Solved by O. U. in 23 mins
Hi I was wondering If someone can please help me with extracting data from a spreadsheet, I am trying to use VLOOKUP but not having any luck I have a spreadsheet which has employees from 3 different companies with multiple entries against most employees. Only this which identifies employees is employee number e.g. A111111 So I need to extract data which belong to employees of 1 company out of 3. e.g. Below is how it looks like Emp_ID Date Product Sale price A111111 3/7/2017 Hair dryer $150 A111112 3/7/2017 Hair cutter $120 A111115 3/7/2017 Nail cutter $12 A111112 3/7/2017 Nail polish $11 A111112 3/7/2017 Hair cutter $120 A111115 3/7/2017 Hair cutter $120 A111112 3/7/2017 Hair cutter $120 A111117 3/7/2017 Hair cutter $120 Table 2 Company Employee ID Company 1 A111111 Company 2 A111112 Company 3 A111115 Company 3 A111117 Any help would be much appreciated
Solved by G. L. in 28 mins
i have an issue with an if and statement. Here it is below: =IF(AND(VLOOKUP(G2,'Campaign Dates'!A$1:B$14,2,0)<B2,VLOOKUP(G2,'Campaign Dates'!A$1:C$14,3,0)>B2),"Previous IO","Active")
Solved by A. S. in 11 mins
Looking to use a drop down list which once a criteria is selected, a formula is produced not a value. Ie/ I have 23 IF AND formulas that I would like to be 'Looked up' once a user selects the relevant selection from the drop down list. VLookup will only produce the cell value not the formula?
Solved by C. J. in 11 mins