Help with nested IfThen Macro

Hi there -

I'm new to macros and having a hard time wrapping my head around the IfThen vs IfThenElse scenarios.

I have a spreadsheet with the following rows:

Sort	NewRenew	NeedsApproval	ClubName
1	New	Yes
1	Renew
3	New	Yes

I'm trying to set up a formula or macro that will do the following:
If NeedsApproval is blank, return "" in ClubName column
If NeedsApproval = Yes, then (if Sort = 1, return "Super Fancy Pants" in ClubName column; if Sort = 3, return "Kinda Fancy Pants" in ClubName column)

If anyone could point me in the right direction, I would great appreciate it!
Thanks so much

Please Login or Register  to view this content.

Thanks so much for the reply, AB33!

Within the Sort # and ClubName pairing, there are 6 options. Do you know if it will present an issue to building out the formula to include that many IF(AND statements?

Nevermind, I actually just answered my own reply - it works just fine

Thanks again - you nailed it with your help/suggested formula!