Hi Experts
I'm trying to make a bill of material sheet.
1. I want to choose from a dropdown list my description ex.(I-Beam,H-Beam,Angle etc).
2. From choosing the description my designation should only show a drop downlist containing what has been chosen in description.
3. And then I want to make a weight cell which fills in the weight according to what has been chosen in the designation.
I have got my I-Beam to work as mentioned in the first 2 steps.
But I had to use subtitue function in my indirect funtion for my datavalidation, because I can't name my tables with names that has spaces and I need my name showing in the cell to have spaces.
This is the formula I used in my data validation =INDIRECT(SUBSTITUTE(D7;"I-Beam";"IBeamList"))
- I-Beam is the name I want to show in my cell
- IBeamList is my table name with all the content I want to show
How will I go about to do this for my H-Beams aswell.
I've tried this formula =INDIRECT(SUBSTITUTE(D7;"I-Beam";"IBeamList"))*INDIRECT(SUBSTITUTE(D7;"H-Beam";"HSectionList")) but get #SPILL! as a return.
I'm not sure how I can achieve this.
I'll be having this issue repeating itself a few more time because of my naming.
I'm also currently doing this in one workbook, will it be easier or better practice to do in sepperate workbooks?
Please if someone could give me some advise on how to fix it or do it differently.
Thank you
Bookmarks