If your data will not extend past column Z:

=LEFT(ADDRESS(ROW(A5),COLUMN(A5)+MATCH(A5,B5:Z5,0) ,2))

If your data might extend past Z (say until AH5):

=LEFT(ADDRESS(ROW(A5),COLUMN(A5)+MATCH(A5,B5:AH5,0 ),2),FIND("$",ADDRESS
(ROW(A5),COLUMN(A5)+MATCH(A5,B5:AH5,0),2))-1)

HTH
Kostis Vezerides


On Nov 13, 5:31*pm, 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)