Kalvinsmith18
New Member
- Joined
- Jul 23, 2019
- Messages
- 2
QTY | Description | Sub-category | Rate | Total |
1 | sprinkler | £ | £ | |
1 | pipe | £ | £ | |
1 | labour | £ | £ | |
1 | design | £ | £ | |
1 | hangers | £ | £ |
<tbody>
</tbody>
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