This will work, I never have used this INDIRECT function before.
My issue now is that I am getting an error in DATA VALIDATION.
My values in MASTER contain spaces, and it appears that I cannot make a list with spaces in list name...
Underscores or dashes in the MASTER name is not really an option.
These values are for display only and no other calculation or reference will be made from the returned values.
Make sense?
Any ideas on this issue?