Hi Guys,
Ok the file is attached.
What I'm trying to achieve is the following;
1) As you can see there is a drop down list in A4 which references a price by VLOOKUP for B4.
2) When this happens the boiler is either a Windhager,Baxi etc etc .. and each Boiler has its own set of Accessories as you can see in the Sheet 'LOOKUPS'.
3) I would like to then be able to bring up a list of the Accessories in B6 but ONLY the ones relevant to the type of Boiler.
Is this possible ?
I am wondering if I need to separate out the boiler type from the description and then base it on that ?
Also presuming I need to use the IF command ?
Thanks in Advance !!
Amit
Bookmarks