Thread: Lookup Across Multiple Columns - Return Category names
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Lookup Across Multiple Columns - Return Category names
Excel 2007
Two more methods:
PivotTable (no formulas)
Tables (with macro)
http://www.mediafire.com/file/1ymtjm...07_13_09a.xlsm
Reply With QuoteReply With Quote