My formula is below. But this is my issue:
I have sheet 1 and sheet 2. I think what I might be trying to do is simple but I'm not sure if it should be a match, match if or index formula.
In sheet 3 in Column A...I have a list of unique names of clothing brands.
In sheet 2 in Column A...I...