Trying to find the first instance of a match and return the column header as a result

try this formula:

Please Login or Register  to view this content.

As it is an array formula, you have to end its editing by pressing CTRL+SHIFT+ENTER at the same time.
You should see these characters around your formula {}
You'll probably want to make some of the ranges ABSOLUTE addresses (as in $B$2:$G$4)
Also, I see a problem as your column A states Kruger but you have Kruger HS in your table.
This formula works out if you have an EXACT match only.

Hi,

another approach

=AGGREGATE(15,6,B$1:G$1/($B$2:G$4$="Kruger"),1)

or

=AGGREGATE(15,6,B$1:G$1/($B$2:G$4$=A10),1)


Hope it helps

mirk, Please upload a small workbook sample. It gives us something real to reference and work with. Remove any sensitive data.

If you aren't familiar with how to do this:

To attach a file to your post,

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”
• be sure to desensitize the data

The file name will appear at the bottom of your reply.