Get instant live Excel expert help and learn how to use an IF function with a VLOOKUP

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.

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.

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?

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),""

How to get the last value froma sheet using vlookup if the same is occuring multiple times ?

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.

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

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

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")

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?