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