This worked perfectly at first, so I thought. But for some reason it is pulling the letter 1 down from it's match (See highlighted matches and it returns that below it).
I've tried so much. I found that formula online and have been messing with it for over 2 hours.
My original need was to auto find the possibilities (1,2,3, and 4) Then have them formulate themselves to the right without so much manual formula input; however, I can't figure out how. VLOOKUP only seems to return one result, this seems to be my best best and having to manually enter the lookup value(A2, A7, Etc) and paste the formula as well as modifying all of the cell references.
I'm open to anything. I'm not good enough for Macros/VBA yet obviously.
Edit:
I have added the worksheet. As you can see, it returns a result 1 item down from what is needed.
I also added what it would ideally look like on the right in red; although, that is text only.
The best scenario is it would find each unique identifier "pump" and add it to the column then sort out the options "product" at that pump.
Ex: It searches the column and finds 1-4, It then puts 1 and all of it's options, then 2, etc.. Not sure if that's reasonable.
Bookmarks