Forum Discussion
Fairly new excel question
Riny_van_Eekelen will this work in terms of me wanting to pull the same multiple values in A and pull all three different codes from column B?
What would an example formula be?
HeatherK That sounds like filtering by "Product". What Excel are you using?
Riny_van_Eekelen Office 365 business - thank you for your patience 🙂
HeatherK See if the formula in B11 works for you and if the result is what you expect to see.
Riny_van_Eekelen thank you that works. Now, if I have 2 worksheets - sheet 1 is as the example, there will be lots of products with multiple individual codes (for colour)
On sheet 2 I have pulled data from a separate database where I have some codes missing for the colours - can I get it to find that one individual description (name) and give me back all the codes in the next column associated with it, to maybe look like the below? Or there about, i'm having to work off 2 sheets. I've done vlookup to separate all my missing data and left with a 'master' where i have to compare what is missing on the database.
I hope I made sense! I know there must be a quicker way for me to do this 😕
name default_code Hillbrush - 254mm General Purpose Brush, Soft D5/G D5/R D5/W D5/Y Hillbrush - 406mm General Purpose Brush, Stiff D9/B D9/G D9/R