Adding more than two arguments to an IF formula

[1232343545444]

I teach classes and I would like to choose the name of a class from a drop down list then have the cell next to it automatically show up with how long the duration of the class was (corresponding to the class chosen). The drop down list is from a pre-written list on a different sheet.
If the IF formula allowed for three or more arguments it would be easy but IF formula only allows for 2. Any help would be much appreciated. Thank you!

 

[Jonmo1]

Welcome to the board.

You could use vlookup.
If you already have al ist of the clesses on a different sheet, put the corresponding durations in an adjescent column.
Then do
=VLOOKUP(A2,'Other Sheet'!A$1:B$10,2,FALSE)

A2 is the name chosen from the dropdown
'Other Sheet' is the name of the other sheet that contains the list.
A1:A10 contains the class names
B1:B10 contains the corresponding durations.

 

[1232343545444]

Thank you so much! It works! But what if I need the class names to be extended to A1:A38 and the duration to B1:B6?

 

[Jonmo1]

Thank you so much! It works!

You're welcome

But what if I need the class names to be extended to A1:A38 and the duration to B1:B6?

I don't understand what you mean.
You need a corresponding duration (in column B) for each class listed (in column A)