Extract data

Copper Contributor

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
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)

@Yachtworks 

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