close

I'm very new to excel and i think i just don't understand a basic function
but i couldn't find it under the help menu.

how can you define a cell using a letter and then a value of another cell?
here is an example
W15=5
D5=10
my guess was =D(W15) which i would like to equal 10, but i get a name error

Hi Todd

Try
=INDIRECT(quot;Dquot;amp;W15)

--
Regards

Roger Govier
Todd Duncombe lt;Todd gt; wrote:
gt; I'm very new to excel and i think i just don't understand a basic
gt; function but i couldn't find it under the help menu.
gt;
gt; how can you define a cell using a letter and then a value of another
gt; cell? here is an example
gt; W15=5
gt; D5=10
gt; my guess was =D(W15) which i would like to equal 10, but i get a name
gt; error

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()