D
Digisafenz
I have a spreadsheet with a drop downlist of choices and then anothe
cell that references to the drop downlist. the dropdown list details ar
stored in a separate worksheet. I want the if statement to allow
reference to the drop down list.
i.e. drop down list is in Column E then the if statement is in column
I- R When I select a choice from the drop down list the columns I-
check to see a match and return a result. The if statement is manuall
configured as follows =IF(E46="Vehicle Signs",F46,0) What I want to d
is be able to absoulute reference " Vehicle Signs" to the drop dow
validation fields in the separate worksheet. This way if I change m
validation details, then the if calculation field changes also.
i hope this make sense. i can post up the spreadsheet somewhere if tha
helps anyone come up with an answer for me.
Thank
cell that references to the drop downlist. the dropdown list details ar
stored in a separate worksheet. I want the if statement to allow
reference to the drop down list.
i.e. drop down list is in Column E then the if statement is in column
I- R When I select a choice from the drop down list the columns I-
check to see a match and return a result. The if statement is manuall
configured as follows =IF(E46="Vehicle Signs",F46,0) What I want to d
is be able to absoulute reference " Vehicle Signs" to the drop dow
validation fields in the separate worksheet. This way if I change m
validation details, then the if calculation field changes also.
i hope this make sense. i can post up the spreadsheet somewhere if tha
helps anyone come up with an answer for me.
Thank