Thread: Returning value from single row of filtered table, given the column header
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Paul Martin - Melbourne, Australia Paul Martin - Melbourne, Australia is offline
external usenet poster
  
Posts: 5
Default Returning value from single row of filtered table, given thecolumn header
I have replaced Tbl_AreaCover[Area 1] with INDIRECT("Tbl_AreaCover[" & SelectedArea & "]", but find SUBTOTAL inadequate for text values. So I'm still stuck.
Reply With QuoteReply With Quote