Hey everyone!
I'm working on a rather complex doc to place products in certain categories.
I have done an "if(isnumber(search" function to put products in certain categories based on their name, and now that I have the results, I want to be able to line up all the categories in one column.
Maybe have a look at the file to understand it better.
In column B are the product names
Column D to K the category results
I would like all the category results to show up in column C (basically ignore the FALSE and only keep the category names)
does anyone have a magic formula for this? I tried Vlookup, hlookup and a bunch more but nothing works...
thanks!
Bookmarks