close

Hi, it is possible to get excel to recognise a cell reference based on a
calculation?
I have this formula which gives me a number that i'd like to use as a row
number.

=IF(N2 gt;1,(CELL(quot;Rowquot;,L3) (CELL(quot;Contentsquot;,N3))),IF(N2
=1,(CELL(quot;Rowquot;,L3) (CELL(quot;Contentsquot;,N3)-1)),quot;Not Parentquot;))

I also know the column letter that I'd like to use, but have no idea how I
can marry the 2 together so that I can then use the CELL(quot;Contentsquot;, )
function on the cell and display the contents in a particular cell.

Any ideas, or if I'm talking gibberish please give me a shout.
Thanks
Dean

Have a look at the INDIRECT( ) function in Help - I think you will find
that it will help you to do what you intend.

Pete

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

    software

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