View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mkloosterboer mkloosterboer is offline
external usenet poster
 
Posts: 1
Default How to reference another cell based on what row a certian header i

I would like to have a cell display the same thing as another cell on another
sheet. But the cell I was to reference might change columns often, but it
will always have the same header at the top of the column. So how can I tell
the cell to look at cell 5 for ex. but in the column that says Activity at
the top? remember that the column will change frequently.