Forum Discussion
Fairly new excel question
Hi - from the example below, I need to look at the product in column A, and return whatever is in column b and c in a new sheet - what's the easiest way to do this? Product Paragon Stock Code...
HeatherK Plenty of choices for you. Depending on your Excel version:
VLOOKUP, INDEX/MATCH, XLOOKUP, FILTER
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.