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? ProductParagon Stock CodeVariantColourLine Marker (750ml)LM/BEBlueLine Marker (750ml)LM/RDRedLine Marker (750ml)LM/WHWhiteLine Marker (750ml)LM/YLYellow

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.

Forum Discussion

HeatherK

Copper Contributor

Feb 21, 2020

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	Variant Colour
Line Marker (750ml)	LM/BE	Blue
Line Marker (750ml)	LM/RD	Red
Line Marker (750ml)	LM/WH	White
Line Marker (750ml)	LM/YL	Yellow

excel

11 Replies

Riny_van_Eekelen
Platinum Contributor
Feb 21, 2020
HeatherK Plenty of choices for you. Depending on your Excel version:
VLOOKUP, INDEX/MATCH, XLOOKUP, FILTER
- HeatherK
  Copper Contributor
  Feb 21, 2020
  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?
  - Riny_van_Eekelen
    Platinum Contributor
    Feb 21, 2020
    HeatherK That sounds like filtering by "Product". What Excel are you using?