Extract data

%3CLINGO-SUB%20id%3D%22lingo-sub-1702032%22%20slang%3D%22en-US%22%3EExtract%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1702032%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20want%20to%20know%20is%20it%20possible%20to%20extract%20data%20from%20a%20pricelist%20that%20matches%20the%20data%20on%20another%20list%20by%20SKU%20code.%26nbsp%3B%20Basically%20I%20have%20an%20updated%20price%20list%20from%20supplier%20with%202000%20products%20and%20I%20have%20my%20shops%20products%20exported%20so%20I%20want%20to%20extract%20just%20the%20ones%20for%20my%20shop%3F%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1702032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1703144%22%20slang%3D%22de-DE%22%3ESubject%3A%20Extract%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1703144%22%20slang%3D%22de-DE%22%3EIt%20is%20always%20an%20advantage%20if%20you%20include%20a%20file%20(without%20sensitive%20data)%20with%20your%20topic.%20This%20way%20you%20can%20be%20helped%20more%20quickly%2C%20and%20some%20of%20the%20people%20here%20can%20suggest%20a%20solution%20that%20suits%20them%20exactly.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, I want to know is it possible to extract data from a pricelist that matches the data on another list by SKU code.  Basically I have an updated price list from supplier with 2000 products and I have my shops products exported so I want to extract just the ones for my shop???

2 Replies
Highlighted
It is always an advantage if you include a file (without sensitive data) with your topic. This way you can be helped more quickly, and some of the people here can suggest a solution that suits them exactly.

Nikolino
I know I don't know anything (Socrates)
Highlighted

@Yachtworks 

Probably XLOOKUP(), INDEX/MATCH or like could help