how do I get a different value for different criteria IF?

[bzymom]

I am trying to create a spreadsheet for a dance studio. If(D4="Ballet", 20), being D4 is the class taken and 20 is the dollar amount, BUT I need it to also do IF(D4="Adv. Ballet), 35), along with many other IFs, as I each class has a different cost. I really appreciate any help, as I haven't worked with Excel for a long time and I am ready to pull out my hair!

[daffodil11]

Welcome to the forum, bzymom!

On another tab, make a small table that you can index later.

For example, A1: Class, B2: Cost

Then down column A list the classes, and in column b list the costs.

Back on the first tab, =VLOOKUP(D4,Sheet2!$A$2:$B$10,2,0)

That will find D4 in the little table you made and return the value in the 2nd column.

[gmr4evr1]

Try this formula in the cell you want the $ amount to appear in ... =IF(D4="Ballet","$20",IF(D4="Adv. Ballet","$35",""))
Sorry, didn't see that someone already answered your post.

[newdoverman]

Perhaps this will get you started. It has the dances in a small table with the associated prices. Then, in column D there is a Data Validation list from which to choose the class and the price will automatically be entered in column E next to the class.

[newdoverman]

@daffodil11

Looks like we have very similar ideas about this.

[daffodil11]

Brilliant minds think alike. I even named a class after you. :D

[bzymom]

The only problem with this solution was I started the spreadsheet with an older version of Excel and it wouldn't allow me to add all of the criteria. I copied the data into a new spreadsheet with the most current version and used the vlookup. Works like a charm! Thank you!

[bzymom]

THANK YOU! Worked like a charm.

[daffodil11]

Glad we could help.