View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Inverse Table Lookup

If your Table is a named array of unique numbers and letters
and your named column and row headers are numbers then find
the column/row of a certain LookupValue with
=SUMPRODUCT((Table=LookupValue)*(ColumnHeader))
=SUMPRODUCT((Table=LookupValue)*(RowHeader))
If LookupValue is text, add " ", like "LookupText"
If the column/row headers are letters or names,
add numbered headers and use LOOKUP to translate.