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

if M contains the word "COVER" as part of the word in that column, e.g. could be "BAR-STOOL-COVER" then vlookup to get the SKU ID from another sheet.

I need help with a formula, I have written one but need to add something else on and just can't seem to work it out? The formula in M9 is:=IF(OR(L9="No Date",L9="Enter Date Here!",L9="-"),"",SUM(L9,730)), What i'm asking is if any of the text is entered in cell L9 then cell M9 will be blank and just do the sum, however I now want to change it, if L9 says "No Date" then M9 displays "Not required". I have another formula in L9 already, which is:=If(ISNA(VLOOKUP(D9,Inputs!S:AE,9,false)),"-",VLOOKUP(D9,Inputs!S:AE,9,false)) this is carrying information across from another sheet. Help???

need to use vlookup function for the following: in one excel sheet i want to type in a certain input, if that input corresponds to with the input in a second excel worksheet then all the data from the second worksheet is displayed on the first worksheet

Need to know if the companies listed in column B appear in column A. I could use a standard vlookup, but there are often differences in spelling (ABC Co vs. ABC Company -- this is a match, but wouldn't necessarily be returned as such in a VLOOKUP).

I was wanting to see if there is a formula or vlookup i could use to populate data into another sheet by date

I am trying to brainstorm on how to get a formula to look up a contract, if it is between a certain date range return the value for the % associated with it. I have 2 tabs that it would be using in a spreadsheet, then it would need to multiply the MPDQ on spreadsheet 1 x the %x a fixed amt 1.084 to give the desired result. I am not sure if I need to say it is November 1 and put in the formula that if it falls between this date range vlookup contract and return this value, or would it be easier to match index and do the calculation?

hi, tried vlookup but not accurate - not sure if vlookup is the right way to go or something else situation - have two columns table (jobID and notes) - have one column table (jobID) want - compare the two jobID columns, if they are the same then in a blank column add notes against the one column table please help as this is needed promptly then more needs to be done thank you

i need to compare emails from two different lists. all of the vlookup, match, and if formulas are not working

I need an explanation for this formula: =IF(G3="OnDemand",(VLOOKUP(CONCATENATE($B$1,C3,D3,E3," ","shared","hrs"),'AWS_8.1.17 Hardware'!B2:BT200000,11,FALSE))*730*J3*I3,IF($F3="Convertible No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard No Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","hrs"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)*730*J3),IF($F3="Standard All Upfront",(VLOOKUP(CONCATENATE(B$1,C3,D3,E3,H3,F3,"shared","quantity"),'AWS_8.1.17 Hardware'!B1:BR78560,11,FALSE)/12*J3)))))

New Perspectives Microsoft Office 365 and Excel 2016 : Comprehensive, Loose-Leaf Version Module 8 Working with Advanced Functions page 528 question #5: In cell B18, create a formula using nested IF functions and VLOOKUP functions to determine what to do with the returns. Use the lookup table in the Return Data worksheet. Refer to Figure 8-46 for some hints on how to create the formula.