View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dicko1 dicko1 is offline
external usenet poster
 
Posts: 8
Default 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.