Returning a non-numerical value that matches another list

Hello,

I have uploaded a simple file showing what im trying to accomplish.

I'm trying to make a formula in the yellow cells. In these cells I want to return the Industry of a company using the table to the left.

I've done a similar thing with numbers before. Although the function doesnt work here, because I dont want to summarize and its a non-numerical value..

I've used "SUMIF($D$5:$J$5;"O6";$D$6:$J$6)", however, its wrong in several ways. But it might make it easier for you to understand what im trying to do.

Maybe the function "Index" or "Match" should be used? I cant figure out how...

/Peter

Another way:

=INDEX($D$6:$J$6,MATCH(O6,$D$5:$J$5,0))

or:

=HLOOKUP(O6,$D$5:$J$6,2,0)