I have a chart that has four columns. I want to bring back the corresponding percentage based upon a few different criteria.
For example: In cell C2, I am trying to attempt the following
- Use the corresponding title in column 'H' that matches the title in column 'A' and then also find the appropriate revenue range in columns 'A&B' and return the appropriate percentage 'column 'K' to column 'C'
For the attached document I have included three samples of what I am trying to do. You will notice what I am trying to automate is in column 'C'.
I am able to do this if I break out each title by separate tables, but I would like to use one data table for the formula if at all possible.
Any help will be appreciated.
Bookmarks