View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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