Hi guys,
I have created the following formula:
It works exactly as it should.Please Login or Register to view this content.
However, this is being used across a number of fields referencing different columns.
Is there a way I can change the lookup array to reference a range or a sequence of cells instead of hard coding the values?
So, in essence, this:
I'm not sure if this is possible - I haven't found any examples that use anything other than hardcoding.Please Login or Register to view this content.
Any help would be very much appreciated
Bookmarks