Is it possible to use a defined name to reference a tab on a worksheet like in the example below where I have used the name "ValidTAB"
=IF(ISNA(VLOOKUP(T12,'[VD.xls]ValidTAB'!$A$1:$R$957,2,FALSE))
If it is indeed possible, how do I format the reference to this defined name?
defined name
=IF(ISNA(VLOOKUP(T12,'[VD.xls]ValidTAB'!$A$1:$R$957,2,FALSE))
If it is indeed possible, how do I format the reference to this defined name?
defined name