manipulating cell references

[gymbeef]

Total excel novice here again....

What I want to do is (for example), if an entered value or a formula resulting in "1". then the result would be displayed in cell A1. If the answer is "17", then it would display in cell A17, etc. In other words I want the value or result to point to the cell where the answer (or some other value) should appear.

Or alternatively, how would I reference a cell relative to where I am now, without using actual cell labels. For example, is there a way to just say "take the value from the cell thats two columns over and one row down"? What I think I want to do is vary those x,y coordinates depending on calculation results. For example, if the result is "1" then take the value from the next column over, if 2, take it from 2 columns over, if negative, then also go one row down, etc.

 

[Bowers74]

For your second question, lookup OFFSET in the help file.

I'm not sure (yet) about the first question.



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Bowers74]

Now, to your first question:

If I understood you right, then you can enter the following formula into cell A1 and AutoFill it down to 20 (for example):

=IF(NOT($C$1=ROW(A1)),"",$C$1)

This formula assumes that your entered value or formula that will return a value (1 or 17 in your post) is located in cell C1.

Honestly, I would love to know what you need something like this for (if I understood you right).



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!