Index match formula but for specific values of column

Hi team,

I have region, I'd and manager columns

I am using index match formula to get manager updated from another reference sheet based on identifier I'd.

But i want this formula to be applied for only cell with region as Asia for example

How to achieve this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!