Hi, I have built a stock list for which part numbers are in Column B (ITEM CODE) and purchase price is in Column E (PURCHASE PRICE).
Values increase over time therefore I require when an item is booked out to search for the most recent (lowest) value within Column E (PURCHASE PRICE), and add this to that row within Column M (BOOKED OUT PRICE).
However if the value is to show in M500, it cannot use a value from 501 and up, as when a new price is included, it will change all previous booked out prices. (I suppose I can lock the starting cell and not the final cell)
Therefore Cell M500 has to search for a part number within B1 to B500 and show the value within the same row between E1 and E500.
Values increase over time therefore I require when an item is booked out to search for the most recent (lowest) value within Column E (PURCHASE PRICE), and add this to that row within Column M (BOOKED OUT PRICE).
However if the value is to show in M500, it cannot use a value from 501 and up, as when a new price is included, it will change all previous booked out prices. (I suppose I can lock the starting cell and not the final cell)
Therefore Cell M500 has to search for a part number within B1 to B500 and show the value within the same row between E1 and E500.