Excel Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2025778%22%20slang%3D%22en-US%22%3EExcel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2025778%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20all%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20build%20a%20sheet%20with%20a%20master%20list%20of%20items%20all%20with%20data%20that%20is%20unique%20to%20the%20first%20cell%20name.%20i%20am%20then%20adding%20sheets%20on%20which%20can%20made%20up%20of%20some%20but%20not%20all%20of%20items%20on%20the%20master%20list.%20on%20the%20additional%20sheets%20I'd%20like%20to%20select%20the%20a%20cell%20name%20and%20it%20bring%20up%20the%20other%20cells%20data%20next%20to%20it%20so%20i%20can%20create%20costings%20for%20a%20kit%20of%20items.%3C%2FP%3E%3CP%3EI'm%20fairly%20basic%20on%20excel%20and%20could%20do%20with%20steering%20the%20right%20way%2Fformula%20or%20even%20if%20it%20is%20possible%3F%3C%2FP%3E%3CP%3Ethanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2025778%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2026327%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2026327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F915442%22%20target%3D%22_blank%22%3E%40rshaw7%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20quite%20sure%20that%20what%20you're%20asking%20for%20is%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20your%20description%20is%20far%20too%20vague%20to%20give%20any%20specific%20advice.%20Would%20it%20be%20possible%20for%20you%20to%20post%20an%20Excel%20file%20with%20an%20example%20of%20the%20kind%20of%20data%20you're%20working%20with--if%20the%20real%20data%20is%20confidential%20or%20proprietary%2C%20then%20use%20fake%20data--what%20it%20looks%20like%20in%20the%20master%20file%2C%20and%20then%20an%20example%20or%20two%20of%20what%20you%20want%20on%20those%20subordinate%20lists.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2027354%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply%2C%20apologies%20its%20vague.%20I%20know%20what%20i'm%20trying%20to%20do%20but%20not%20the%20correct%20terminology%20to%20do%20it.%20i've%20attached%20the%20sheet%20as%20there%20isn't%20any%20sensitive%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esheet1%20is%20a%20master%20library%20of%20costings%20in%20cells%20against%20an%20item%20reference%20in%20another%20cell.%20i'd%20like%20to%20create%20additional%20sheets%20where%20i%20can%20choose%20items%20off%20the%20first%20sheet%20and%20it%20pulls%20through%20the%20costings%20with%20it.%3C%2FP%3E%3CP%3Ei%20also%20need%20the%20additional%20sheets%20to%20update%20if%20i%20chance%20a%20price%20on%20the%20master%20library%20as%20well.%20i've%20put%20some%20basic%20formulas%20in%20but%20i'm%20sure%20it%20can%20be%20done%20more%20robustly%20than%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

hi all,

I'm trying to build a sheet with a master list of items all with data that is unique to the first cell name. i am then adding sheets on which can made up of some but not all of items on the master list. on the additional sheets I'd like to select the a cell name and it bring up the other cells data next to it so i can create costings for a kit of items.

I'm fairly basic on excel and could do with steering the right way/formula or even if it is possible?

thanks in advance

7 Replies

@rshaw7 

 

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.

 

 

@mathetes 

 

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.

@rshaw7 

 

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.

 

 

@rshaw7 

 

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

Perhaps, you should learn how to use Index & Match which is way more powerful, dynamic and doesn't break unlike VLOOKUP while adding more columns in the data-set.
A quick video will help you understand:
https://youtu.be/3S4DuYjeWKQ

@Rich99 

 

Thankyou for your help. i haven't had to use excel in great depth before now so this is a massive step forward. 

 

thanks again,

Ross

@mathetes 

 

Thank you as well for your help and comments. I will enjoy getting to grips with this as my need to use excel increases.

 

Regards,

Ross