Thread: Lookup value,return column heading
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Moseley Alan Moseley is offline
external usenet poster
  
Posts: 75
Default Lookup value,return column heading
Try INDEX(A4:Z4,1,MATCH(A5,B5:Z5))
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"MFM" wrote:

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