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

I have a sheet that calculates my expenses for each year based on a list that uses vlookup for a value that I use in some of my calculations. If it is year 1 the end of my table comes up with a total calculation, if it is year 2 in the drop down list then the end of my table comes up with a different number after I change the drop down list from year 1 to year 2. Now I want a summary on another page that says: Year 1 $x Year 2 $y How can I get my summary when I can only see one calculation like $x when my drop down list is on Year 1?

1) I am trying to make an overview for co-workers. They import the articles they write for us. And I should see right away which price they will get paid for their work. You will find that information at 'Source'. It should pick the right price (2 options) for different kind of works for different kind of ppl. I tried it with =(IF this cell shows 'Interview' then VLOOKUP pick that price in the table, otherwise pick the other price). I think I know excel a little bit but I'm so frustrated it doesn't work. Maybe I have a knot in my head or my excel is not my friend any more. Help on this part highly appreciated. Every co-worker has a unique price. So I connected the cells that every value should be clearly traced back to the person. 2) But this price-information should be disclosed that none of the co-workers sees the payment form the others (that's the easy part I guess). 3) At the end I need a summary (pivot) which shows me a summary per month/per head and in total. But I already fail on the first part. Thank you so much.

I am trying to make an overview for co-workers. They import lines with articles they write for us. And I (not the others) should see right away which price they will get paid for their work. You will find that information at 'Source'. It should pick the right price (2 options) for different kind of works for different kind of ppl. I tried it with =(IF this cell shows 'Interview' then VLOOKUP pick that price in the table, otherwise pick the other price). I think I know excel a little bit but I'm so frustrated it doesn't work. Maybe I have a knot in my head or my excel is not my friend any more. Help on this part highly appreciated. Every co-worker has a unique price. So I connected the cells that every value should be clearly traced back to the person.

Need help calculating commission based on the excel file I am attaching. The determination of the appropriate commission requires more complicated logic than the base pay. It is recommended that you add a column for “Commission Sales” where you create a formula using the VLOOKUP function to determine how much sales the associate requires for commission (# of hours multiplied by Hourly Sales in the lookup table – this will give you the amount of sales that is required to earn commission). Once you have calculated this, the commission formula must determine if a commission is to be paid, the applicable commission rate, the portion of sales on which to base the commission. Since the commission formula involves several lookups and decisions, you realize that nesting the IF and VLOOKUP functions is required.

the commission formula must determine if a commission is to be paid, the applicable commission rate, the portion of sales on which to base the commission. Since the commission formula involves several lookups and decisions, you realize that nesting the IF and VLOOKUP functions is required. The commisson figures are located on the Data sheet and the total hours worked for each employee is on the last sheet.

Is there a way to write a formula in a cell (Vlookup) and and also be able to type into that cell later if you dont want to use the Vlookup value? Kind of like a hidden formula (vlookup)

I am trying to use vlookup but I don't know if I am using it right

Hi, Could you explain this into plain english please? =IF(AND($AY6552="SO",VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)=3.06),"Bolt On",IF(AND($AY6552="SO",VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)<>3.06),VLOOKUP((VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)),'Product List'!$N:$U,8,0),VLOOKUP((VLOOKUP($A6552,'Priority Lookup'!$A:$C,3,0)),'Product List'!$O:$U,7,0)))

In the PRICE column (this price per item), create a formula using the VLOOKUP, to grab the price of the item typed into the ITEM column, but, wait, take 10% off if the QTY is 5 or more! See next page for a more complete list with Item prices for quantities above 5, and below 5. Note that we are only interested in the price per item. Later a Total column can be added to simply multiply the price * qty.

I have a pretty complicated formula that I am trying to work out. I assume I need to use IF & VLOOKUP in the one formula to make this work, but I cannot get it to work how I want it to and I am not even sure it can happen. So I want to type a Team Name into say call A2 (Finals 1 sheet), down below I have Players Numbers & Players Name A5:B15. I have a "Players List" sheet that already have the completed names & numbers in it. Is there a way that I can type the team name into A2 and it automatically populates the player numbers & names into the cells below?