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