spaces?

=OFFSET(INDIRECT(TRIM(a1)),-15,0)

--
Don Guillett
SalesAid Software

"Caledonia" wrote in message
...
I did -- I get #REF! I tried it with different rows -- not working! If I
put A1 in quotes, it works but it's pulling the data from Sheet!1 A1, not
from Sheet!2 D40.

"Don Guillett" wrote:

try
=OFFSET(INDIRECT(a1),-15,0)
--
Don Guillett
SalesAid Software

"Caledonia" wrote in message
...
Thanks, Don

I had tried Indirect but it returns #REF.

"Don Guillett" wrote:

Have a look in the help index for INDIRECT
--
Don Guillett
SalesAid Software

"Caledonia" wrote in message
...
Sheet1 A1 shows: =Sheet2!D40

What I'm trying to do is: Offset (Sheet2!D40,-15,0)

I want to do this on Sheet 1 off of cell A1: Offset (Cell
referenced
in
cell A1,-15, 0).

Is this possible?