View Single Post
  #1   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 the column header

Hi, I have a table of data by regions (regions are the column headers) that is always filtered to return only one valid row of data. If a region is selected in elsewhere in a cell, I'd like to be able to return the relevant value from the single row of the filtered table. Any suggestions appreciated.. TIA