Auto-updating Price List via invoices

Hey all,

I have been using a price book that uses a simple table EG Code, Name, Price for storing my product prices. I have it auto updating from another sheet in the same book so that as I update my recent invoices it updates the product automatically. another employee recently used it and rearranged the cells and broke the entire workbook.

Is there a better way to have this set out? I'm only using simple =Sheet2!C14 formulas so I understand its fickle nature.

Is there a better layout to use from the start? or just better formulas? open to any and all suggestions.

it would be nice if the table could be re-arranged without breaking the book

Thank you all

Maybe a vlookup or xlookup (depending on the version of excel you have) or index/match but without a workbook to look at it is difficult to make a good recommendation. See the instructions in the yellow banner at the top of the post.

here it is with a simple vlookup, expand the ranges per your data...
=VLOOKUP(A2,Invoices!$A$3:$E$5,5,FALSE)
format as currency, this should work if your invoices tab gets "rearranged".

Great, glad I could help, AND thank you for the rep!