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
|