What is even more weird is that I can take an indirect formula that is
working and put it in one of the sheets and it will not work.

"Brad" wrote:

I agree that getting the value error is odd. When I'm in four certain tabs -
the indirect does not "link" the letters and numbers together. In going
through the formula evaluator -
=Indirect("G"&11+ad65)
=Indirect("G"&11+65)
=Indirect("G"&76)
#value

Rather than giving me Indirect("G76")

Don't know why....

"vezerid" wrote:

What is the value stored in AD65? Try, in the formula bar, to select
the INDIRECT argument i.e. "G"&11+ad65 and press F9. What does the
expression evaluate to?

The strange thing is you are getting #VALUE! and not #REF!. This is
likely if INDIRECT interprets the argument as a range rather than a
single cell, in which case you would need to array-enter it to avoid
#VALUE!.

HTH
Kostis Vezerides

On Dec 11, 6:16 pm, Brad wrote:
On one particular sheet I'm having problem getting indirect to work

=indirect("G"&11+ad65) will give me a value error -

However

=indirect("G"&text(11+ad65,"##)) - will give me the correct answer

In the same workbook - the first method of indirect works just fine.

Does anyone know what is going on with this?