moccasinus
New Member
- Joined
- Aug 8, 2017
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi,
I'm having hard time trying to figure out how to match multiple criteria, that is both vertical and horizontal, and so on.
I've concacenated with transpose, and so on, and so on, in this forum also found AND(EXACT(... that doesn't work either.
The aim is to have AB2:AD4 formatted in color if they match all the criteria, which is based on info in second picture (can I bake all products with a particular raw material instead of the original one)
If all products can be baked with a "match" sugar or flour, etc, then I'd like either to format AB2:AD4 in green color, or add thin columns next to Code1 P/N for "true" or whatever.
I can have the same table of B2:M4 next to the matching product below, but with that still couldn't figure out a way to do it.
I know it sounds really incoherent, hope you get the idea, if not please ask
I'm having hard time trying to figure out how to match multiple criteria, that is both vertical and horizontal, and so on.
I've concacenated with transpose, and so on, and so on, in this forum also found AND(EXACT(... that doesn't work either.
The aim is to have AB2:AD4 formatted in color if they match all the criteria, which is based on info in second picture (can I bake all products with a particular raw material instead of the original one)
If all products can be baked with a "match" sugar or flour, etc, then I'd like either to format AB2:AD4 in green color, or add thin columns next to Code1 P/N for "true" or whatever.
I can have the same table of B2:M4 next to the matching product below, but with that still couldn't figure out a way to do it.
I know it sounds really incoherent, hope you get the idea, if not please ask