Formulas pulling from other tables
I am looking to write a formula on a summary sheet that will pull
totals from a data sheet. The problem is that the cells that contain
the totals changes from month to month and based on how I sort the
information. Is there a way to write the formula so it looks for the
column/row names, rather than the cell.
|