Please Help: Want to auto populate a cell based on the combination of two other cells

[rollsy]

Hi all. So I am completely illiterate with excel formulas but I'm wondering if someone could help me.

I want to make a Personal Trainer Tracker, for gym management to see how much the PTs need to be paid.

Members can buy packages of personal training. EG, they can buy a pack of 5 x 60 min sessions, or 10 x 60 min sessions, or 5 x 30 min sessions, etc.
Obviously, the bigger pack they buy, the cheaper per session it works out to be. EG 5 x 60 min sessions = 38 pounds per session, whereas 10 sessions = 35 pounds per session.

The way the PTs get paid is like this: If you do a session on your shift, you get 40%, if you do it off shift, you get 60%.

I have created Drop down menus for the packages, (So I have a drop down menu where you can select if its 5 x 60 min; 10 x 60 min etc), as well as whether or not it was done on shift or off shift.

So what I would like is for the amount column to auto populate with the amount owed to the PT based on the package and whether or not it was on shift.

EG, if I select "5 x 60 min" from the session type drop down, and "On Shift" from the On/Off shift drop down, I would like $15,20 to populate in the amount column,

I have tried my luck with simple If AND formulas, and V Look ups. I always get an error because I am dumb.

I have attached the excel, and would be hugely grateful for help.

[mrice]

Try

=IF(E3 = "On Shift",VLOOKUP(D3,'Session Rates On Shift'!A:B,2,0),VLOOKUP('July Tracker'!D3,'Session Rates Off Shift'!A:B,2))

[rollsy]

omg you legend, thank you.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.