Thread: Lookup value,return column heading
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MFM MFM is offline
external usenet poster
  
Posts: 10
Default Lookup value,return column heading
I am trying to locate a matching value and return its columnheading.
Ex A5=vlaue to find in row5 to return column heading a4:z4

hlookup(a5,b5:z5,(return matching column heading a4:z4),0)

Reply With QuoteReply With Quote