Reverse lookup. Search header/title from the data

[babychai]

Lookup.png

Hi,

In column B is the result that i need. What is the formula in column B that can lookup the title in cells D2 to F2? Column A is the condition/criteria.

Thanks.

[Fluff13]

In B2 copied down
=INDEX($D$2:$F$2,AGGREGATE(15,6,(COLUMN($D$2:$F$2)-COLUMN($D$2)+1)/($D$3:$F$6=A4),1))

[babychai]

Fluff13, thank you. work great^^

[Fluff13]

You're welcome & thanks for the feedback.