Hi, I have an Index Functionthat searches a table and returns the Column heading if it finds a matching name. The problem is that if it does not find a matching name it returns the Heading of the first Column instead of blank (""). Your help is appreciated. An explanation of how it works would be awesome as I am trying to learn as I go.![]()
=INDEX(A$1:F$1,MAX(IF(A$2:F$7=H2,COLUMN(A2:F7)-COLUMN(A2)+1)))
Bookmarks