Problems with indirect
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
|