I have a data sheet. I also have a consultant sheet.
I would like to setup a 'lookup' array on the consultant sheet to dynamically return the ID values (orange) for the noted owner (yellow).
Thereby, if I change the owner on the consultant sheet, the data will update to the new owner. This data will grow over time.
Once I have this array syntax, I can create the arrays for the other.
Is this the best way of doing it? Or should I instead use some sort of filter setup that references the data sheet? The data sheet needs to stay raw, without a filter.
Thanks for your help