What is in cell AD65 it is just a number in this example it is 65 (it could
also be 55 or 60)

What is in cell ("G"&11+Whateverisinad65) - just a sum of other numbers -
not an array. example =SUM(F96:F$130)

This is not a mistake in typing

Just a bit of clarification - there are four tabs that I can't get the
indirect to work without using the text command. - going through Evaluate
formula - it doesn't attach the two components (the letters and the numbers
together). However, if I add a new worksheet - the conventional indirect
works just fine.

"Dave Peterson" wrote:

What's in AD65? Is it a number?

What's in the cell (G<11+whateverisinad65)

And it's probably best to post the formulas you actually used in the worksheet
instead of retyping them in the message.

Maybe you made a mistake in the formulas you posted--for instance, the second
one isn't correct. Maybe the same thing happened in the worksheet???

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?

--

Dave Peterson