Kalvinsmith18
New Member
- Joined
- Jul 23, 2019
- Messages
- 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]QTY
[/TD]
[TD="align: center"]Description
[/TD]
[TD="align: center"]Sub-category
[/TD]
[TD="align: center"]Rate
[/TD]
[TD="align: center"]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]sprinkler
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]pipe
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]labour
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]design
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]hangers
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
</tbody>[/TABLE]
So, I'm working on a spread sheet for work but hit a bit of a wall. I’ve got part of this spread sheet to work. This is just a small example of what I’m trying to do cause the proper version is going to be pretty big.
I got prices/rates to automatically appear depending onthe option selected in the drop down menu in the "description" using this formula:
=IF($D3="",0,VLOOKUP($D3,Sheet2!$C:$D,2,FALSE))
But what I didn’t realise was the spread sheet I made had one column for the item/material but in practice that list will be massive and difficult to find exactly what it is you’d be looking for. So I’ve added a sub-category but what I’m stuck with is selecting, for example,“sprinklers” as the main option in that drop down box and then that automatically narrows down the options available in the sub category to the table for sprinklers. This then would update the rate and price etc that would appear next to it. The table of sprinklers and other items would be listed on a separate sheet.
I tried to attach an example but don't know how to.
Cheers
<tbody>[TR]
[TD="align: center"]QTY
[/TD]
[TD="align: center"]Description
[/TD]
[TD="align: center"]Sub-category
[/TD]
[TD="align: center"]Rate
[/TD]
[TD="align: center"]Total
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]sprinkler
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]pipe
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]labour
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]design
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]hangers
[/TD]
[TD][/TD]
[TD]£
[/TD]
[TD]£
[/TD]
[/TR]
</tbody>[/TABLE]
So, I'm working on a spread sheet for work but hit a bit of a wall. I’ve got part of this spread sheet to work. This is just a small example of what I’m trying to do cause the proper version is going to be pretty big.
I got prices/rates to automatically appear depending onthe option selected in the drop down menu in the "description" using this formula:
=IF($D3="",0,VLOOKUP($D3,Sheet2!$C:$D,2,FALSE))
But what I didn’t realise was the spread sheet I made had one column for the item/material but in practice that list will be massive and difficult to find exactly what it is you’d be looking for. So I’ve added a sub-category but what I’m stuck with is selecting, for example,“sprinklers” as the main option in that drop down box and then that automatically narrows down the options available in the sub category to the table for sprinklers. This then would update the rate and price etc that would appear next to it. The table of sprinklers and other items would be listed on a separate sheet.
I tried to attach an example but don't know how to.
Cheers