I would agree that trying to add 65 to "G11" would not work - however that is
not what the formula is doing - I'm taking "G" and add it 11+65 or 76 to end
up with "G76".

This is not the first time that I have used this feature of Excel - however
this is the first time that it hasn't worked. What is weird is that I can
add a worksheet and the fomula will work okay on that sheet, but not the
sheets that I need.

There are no macro's that are running in the background....

"David Biddulph" wrote:

In your first expression you have a text string "G11", formed from the
concatenation of "G" with 11, and then you are trying to conduct an
arithmetic add (with the + symbol) between that text string and the content
of AD65. You can't do an arithmetic add on a text string like "G11".

In your second expression you are conducting an arithmetic operation to add
the number 11 to what is presumably a number in AD65. The result of this
arithmetic operation is a number, which you are then converting to text with
the TEXT function, then concatenating that text to the text "G", and the
resulting text string is the input to the INDIRECT function.

You say that in the same workbook the first method works just fine. Exactly
what is the formula that you think works, and what are the values in the
cells which are inputs to that formula?
--
David Biddulph

"Brad" wrote in message
...
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?