I have a spreadsheet with a drop downlist of choices and then another cell that references to the drop downlist. the dropdown list details are stored in a separate worksheet. I want the if statement to allow a reference to the drop down list.

i.e. drop down list is in Column E then the if statement is in columns I- R When I select a choice from the drop down list the columns I-R check to see a match and return a result. The if statement is manually configured as follows =IF(E46="Vehicle Signs",F46,0) What I want to do is be able to absoulute reference " Vehicle Signs" to the drop down validation fields in the separate worksheet. This way if I change my validation details, then the if calculation field changes also.

i hope this make sense. i can post up the spreadsheet somewhere if that helps anyone come up with an answer for me.

Thanks