Hi , i was wondering if there is an easier way to write formulas that lookup information across multiple criteria that sit in different columns
For example, i was working on a report where i had to pull 8 diff set of criteria. As a result i had to create 8 different concatenates, and then create lookups off the 8 concatenates.
It became a little time consuming each time my bosses would add additional data to pull.
Each time they asked for additional info, i had to add extra columns in my report to create a different concatenate.
Is there a more efficient way?
For example, i was working on a report where i had to pull 8 diff set of criteria. As a result i had to create 8 different concatenates, and then create lookups off the 8 concatenates.
It became a little time consuming each time my bosses would add additional data to pull.
Each time they asked for additional info, i had to add extra columns in my report to create a different concatenate.
Is there a more efficient way?