Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Updating shortened price list from a master price list

I'm updating the pricing on 1020 items that our store sells from a manufacturer who sells more than 5000 items, we just do not sell them all.


Is there a way to get the new prices for my 1020 items out of the master price list of 5000 items without searching each part number individually?


I have both spreadsheets as sheets within one Numbers file now.


Mac mini 2018 or later

Posted on Feb 25, 2021 2:30 PM

Reply
Question marked as Best answer

Hi travisroy,


The VLOOKUP function will do this.



Formula in B2 of the Short List table: VLOOKUP(A2,Master List::A:B,2,0)

Fill down to the bottom of that column.


If your Master list not that simple, please post a screen shot so that we can see what you see.


Regards,

Ian.

Posted on Feb 25, 2021 8:49 PM

1 reply

Updating shortened price list from a master price list

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.