Can someone help me with this IF INDEX MATCH formula?

I want to make a formula that searches another sheet and if the 1st budget is "Philadelphia", then show 1st budget amount. Otherwise, show the second budget amount.

Let me know if I am way off. Thanks!

=IF(INDEX({1st_Budget}, MATCH([Row ID]@row, {Row_ID})) = “Philadelphia”, INDEX({1st Budget Amount Approved}, MATCH([Row ID]@row, {Row_ID})), INDEX({2nd Budget Amount Approved}, MATCH([Row ID]@row, {Row_ID}))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!