=INDIRECT(ADDRESS(4,MIN(IF(B3:F40=G9;COLUMN(B3:F40 ),""))))

CTRL+SHIFT+ENTER it as this is an array-formula

HIH

On 15 Maj, 10:14, Dingerz wrote:
Hello,

I dont really know how to explain what I want so I will try it in the best
way i can.

If Referenced Cell (G9) matches another cell in table (B3:F40) then make
current cell (the one i am writing the formula in) equal to Row 4 of the
particula column where the match was found.

In essence i want it to find some data in a table and tell me the header of
the column where it was found.