specifying a cell by referencing another cell




Say I have the value "13" in cell A3.  Then, in another cell, say B3, I
want to specify the value in column B and row whatever-is-in-A3.  I've
tried expressions in B3 like:

=B(A3)
=B[A3]
=B$A3

and so forth.  But I can't figure out what the syntax would be.

Any total gurus know the right combination of letters and characters to
do this?


tia,
ken

-- 
"To make an apple pie from scratch,
first create the universe."
        -- Carl Sagan




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]