Using Defined Names

[Mr Nick]

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

 

[paelinck]

I think it should be possible using the Indirect function. Your function would look like this:

=IF(ISNA(VLOOKUP(T12,INDIRECT("'[VD.xls]'"&A1&"'!$A$1:$R$957"),2,FALSE))

where A1 would have the value ValidTAB.

Marc

 

[Mr Nick]

I have tried this method and get a #REF! value returned to the cell.

I'm getting a bit fed up now and think I may resign!!