Index match formula but for specific values of column
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
Check out the Formula Handbook template!