Hi Guys & Girls,
Got one that is causing me a few headaches... I have cell which needs to generate a value dependant on two types of style and two lots of categories. What I am looking for is a formula to recognise the following..
Cell H23 has two options - W or D which is a data validation drop down list.
Once W or D is selected, Cell A5 then has an INDIRECT data validation of categories to choose from which are based on the initial selection of W or D, which again is a drop down list to choose from.
Once the category in Cell A5 has been selected, then this will generate a value in Cell L4 which has an IF formula in it which states the correct numerical value based on the selected W or D and the relevant category selected in A5.
The problem I am having is I cant work out how to make the formula in Cell L4 recognise both the selections previously made in H23 & A5.
Can anyone point me in the right direction??
Bookmarks