Forum Discussion
Excel Help
I'm quite sure that what you're asking for is possible.
Unfortunately, your description is far too vague to give any specific advice. Would it be possible for you to post an Excel file with an example of the kind of data you're working with--if the real data is confidential or proprietary, then use fake data--what it looks like in the master file, and then an example or two of what you want on those subordinate lists.
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
Hi,
I have made your master sheet into a table and used a simple VLOOKUP formula for the data on the KIT 1 sheet. Hope this helps.