If
You actually have a single cell with the range name "curbal"
AND
that cell is always in Row_1
AND
you want to return the value that is 1 cell to the left and 1 cell down from
curbal

then try this:
=OFFSET(curbal,1,-1,1,1)

If curbal is in cell F1
that formula will return the value from E2

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"HERNAN" wrote:

what's wrong with this formula?

=offset(curbal,0,-1,1,1)

I'm trying to get the data of the cell ON THE LEFT of the one named "Curbal"

ie:

a b c d
1 x Curbal
2 9

I don't know where is going to be located neither the name of the column the
only thing I know its going to be on row 1 and is going to be on the left of
the one named "Curbal"
So in this example the number I want to get is 9