Novice Smartsheet User! Need help with Matching/Indexing

I need help with a formula! I'll try to explain this as clearly as I can.

I need a formula that can tell me the value I circled looking within the range of columns "01. Kick-Off Meeting" to "13. New Contract Start", based on the corresponding "Task Name" column, in this example, "Kick-Off Meeting" if the "Task Status" column is "Milestone".

The formula would go under "Task Status" where the cell is selected in the image.

These two images are from the same sheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!