Instead of using:

t(E1)

Use:

INDIRECT(E1)

However, this will not work if the named range is defined using functions
like OFFSET.

--
Biff
Microsoft Excel MVP


"tjfwestcoast" wrote in message
...
I have a formula in my spreadsheet that looks like:

=IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot
Tables'!$A$403:$A$418,MATCH($D11,t(E1),-1))))

In cell E1 I have the following text: gtalbo
In the PF Kintanas Pivot Tables tab I have a named range with the name:
gtalbo

When I try to use the above formula I get the #Value! error. If I
substitute the actual name of the range in the formula it works:

=IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot
Tables'!$A$403:$A$418,MATCH($D11,gtalbo,-1))))

Is there anyway to make the cell reference work?

PS. I noticed when I performed the F9 function on the t(e1) portion of
the
formula I get the result of:

=IF(D11=0," ",IF(C11<D11,"Not Enough Hours",INDEX('PF Kintanas Pivot
Tables'!$A$403:$A$418,MATCH($D11,"gtalbo",-1))))

Can I strip the quotes from this and make it work?