Thread: pick from table based on row and column header
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PBcorn PBcorn is offline
external usenet poster
  
Posts: 79
Default pick from table based on row and column header
whats the best way to pick single values from a table based on text column
and row headers, i.e:

ABC
D 2
E
F

B:D=2

it has to be done using headers as new columns may be added

thanks

Reply With QuoteReply With Quote