Hoping someone can help with this one. I suspect it's some kind of vlookup formula that I need but can't quite figure out how to do it.
I'm trying to populate Sheet1 by looking up the data in Sheet2.
The lookup would be based on the Order ID number and I'm trying to highlight what Product Types were bought on each individual order - I've manually input the corresponding data on Sheet1 with a letter Y to indicate how it should look.
Hoping there is a quick and simple vlookup formula to run on this? I guess it doesn't need to show a Y (binary number would be fine and I could just change to a Y after the sheet is completed with Ctrl H).
Sample data is attached - if anyone can add the actual formula to use in the data sheet it would be greatly appreciated.
Bookmarks