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
Bookmarks