I'm using data validation for dependent lists. I get the error "The source currently evaluates to an error. Do you want to continue" if i copy the formula below into DV box. If I click yes, the cell dropdown menu does not work, i.e., open the list, it puts a black funny face (error symbol). I set up a test in a cell on the worksheet and the formula works but it fails when copied into DV formula box...HELP!
=IF(VLOOKUP($L6,CODE.TAKEOFF.TYPE.TBL,CODE.TAKEOFF.LKUP2,FALSE)=CODE.TAKEOFF.LKUP.FLR,SCHED.BLDG.DIMS.FLR.HT.LIST, IF(VLOOKUP($L6,CODE.TAKEOFF.TYPE.TBL,CODE.TAKEOFF.LKUP2,FALSE)=CODE.TAKEOFF.LKUP.MOD,SCHED.BLDG.DIMS.MODULE.LIST))
=IF(VLOOKUP($L6,CODE.TAKEOFF.TYPE.TBL,CODE.TAKEOFF.LKUP2,FALSE)=CODE.TAKEOFF.LKUP.FLR,SCHED.BLDG.DIMS.FLR.HT.LIST, IF(VLOOKUP($L6,CODE.TAKEOFF.TYPE.TBL,CODE.TAKEOFF.LKUP2,FALSE)=CODE.TAKEOFF.LKUP.MOD,SCHED.BLDG.DIMS.MODULE.LIST))
