Forum Discussion

rshaw7's avatar
rshaw7
Copper Contributor
Jan 01, 2021

Excel Help

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 ...
excel
Formulas and Functions
rshaw7's avatar
rshaw7
Copper Contributor
Jan 03, 2021

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.

Rich99's avatar
Rich99
Iron Contributor
Jan 03, 2021

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's avatar
    rshaw7
    Copper Contributor
    Jan 03, 2021

    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

Resources