Forum Discussion
Excel Help
Thank you for your reply, apologies its vague. I know what i'm trying to do but not the correct terminology to do it. i've attached the sheet as there isn't any sensitive data.
sheet1 is a master library of costings in cells against an item reference in another cell. i'd like to create additional sheets where i can choose items off the first sheet and it pulls through the costings with it.
i also need the additional sheets to update if i chance a price on the master library as well. i've put some basic formulas in but i'm sure it can be done more robustly than this.
thank you.
Just to supplement the solution given you by Rich99 , here's a good reference link where you can deepen your understanding of how to use Excel. The VLOOKUP function is far and away one of the most popular--for exactly the kind of application you have. https://exceljet.net/excel-functions/excel-vlookup-function
Welcome to the adventure of Excel. Have fun using it more each day