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

my working formula is =IF(K15<=201,VLOOKUP(K12,'CHANGED RATES'!A1:H38,5,FALSE)*K15+130) if K15 is 100 and the Vlookup is 6.01 i want the answer to be 731 /0.7 = 1044.29.

I am dealing with some sales tax reports in which I base my calculations off the two letter state abbreviation. However, sometimes my report will spit out the full state name. Currently my column B is where my two letter state abbreviations and full state names appear. How do I tell Excel to convert the full state name into a two letter abbreviation? Do I need a new column? If so, can I make the state abbreviation copy over if it is correct? Would I need a reference table of all state names and abbreviations? I'm not sure if this is just formulas or a combo between formulas and vlookup. I'll upload an example file.

Hi I'm a novice and I'm trying to do a formula that I think needs 2 if's and a vlookup. but cant seem to get it to work.

Need to find a formula that lets me take the average of a part of the table if it's earlier column matches certain text. Vlookup maybe? Not adept with that

In cell H7, create a nested if formula that will give the same results as the previous vlookup formula. Copy and paste the formula down the rest of the database.

Trying tocompare 2 columns in excel that should have the same data, and then if they do have "Yes" in the 4th column. If they don't have "No" in the 4th column. I can do this comparing 2 columns with this: =IF(ISNA(VLOOKUP(A2,$C$2:$C$175,1,FALSE)), "No", "Yes") But how do I add the 3rd column(Column B)

I have a final Wednesday, and I would like a demonstration of how to use Vlookup and IF function for beginners

Need my total formula to be divided by 0.8: FORMULA: =IF(M16<=500,VLOOKUP(M12,'Altered rates'!A3:E35,3,FALSE)*Calculator!M16+250,IF(AND(M16>=501,M16<1001),VLOOKUP(M12,'Altered rates'!A3:E35,4,FALSE)*Calculator!M16+250,IF(M16>=1001,VLOOKUP(M12,'Altered rates'!A3:E35,5,FALSE)*Calculator!M16+250)))+IF(M12="SWITZERLAND",100)+IF(M12="NORWAY, (Oslo)",-100)+IF(M12="REPUBLIC OF IRELAND",-61)+IF(M12="N. IRELAND",-150)

In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.)

I need help creating a formula for a vlookup with multiple IF scenarios, an example would be an Excel document with three tabs.The first tab would have a question of yes or no or a multiple-choice answer of five different products. The second tab would have our complete inventory list with indexing numbers and descriptions.The third Tab would be raw data inputted from an another Excel document that is General item type and QTY. Essentially I'm creating a pick list.