Feb 27 2022 07:21 PM - edited Feb 27 2022 07:34 PM
I have an Excel file that I use to keep up with pricing, this file is represented by the first attached picture. I also get a file from my supplier every month that gives me the updated cost of items for the month. This file is represented by the second attached picture. I have been going through and manually changing the cost price, but lately the number of items on my list has grown to over 5,000 and it is very time consuming to do manually. I need to find a way to change the cost price in my file to what is in my suppliers file on a monthly basis. Another issue is that I do not have everything on my list that is on my suppliers list, I have say 5,000 items and they have over 20,000 items so I can't just copy and paste. If someone has a solution it would be greatly appreciated.
Feb 27 2022 10:02 PM
You would use vlookup function, that will help you.
=IFERROR(VLOOKUP(A3,[Book2]Sheet1!$A$1:$B$20,2,FALSE),"Item not available")
write this formula in G3 (the cost), then fill it down the whole table, it will bring you the price from the work book called Book2, Sheet1 as the names in your picture.
If the item is not available, it will show you "item not available"
Mar 01 2022 07:00 PM
Mar 01 2022 10:02 PM