I am creating a file that summarizes commissions paid for the entire year.
One sheet (the top portion of the file) contains all salemen detail (quota, payout rates, revenue, adjustments, bonuses, etc.)
The bottom part of the sheet is the destination sheet (where I would put the formulas). What kind of formulas (Index, offset, Match, Choose, etc) would I use to pull the information from the detail sheet? At present, I am using the index function to do this. My main concern is that at the year progresses, rows may be added which may affect the links. This is why I was thinking about using the match function but don't know how to use it in this information.
Vlookup I feel won't work because of the table structure.
Thanks