Forum Discussion
Help with either VLOOKUP or IF AND statements
I switched to an AGGREGATE() formula. See attached file.
Hi
Neither VLOOKUP() nor IF() but INDEX() and MATCH().
Note: To make the formula work you have to remove some trailing spaces.
Hello Detlef,
I think we are on the right path here. The other thing is however, that for some samples, it does not follow the exact formula of "Color - Taste - Smell - Appearance - Shape". For instance, some of my sample names might just have "Color - Taste" or it might be out of order such as "Taste - Color - Smell".
That's why I was trying to look up for two matching values in case they happen to be out of order. I like the match function because that seems to be exactly what I'm looking for! However for the columns labeled 0-4, these values will get mixed up if the "analysis" deviates from what I showed. I should have specified that in the original post! That is my bad.