Hello.
I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.
Is this possible, or is there a better way of achieving the same goal?
Any assistance provide will be much appreciated. Thank you.