T
tjfwestcoast
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?
=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?