cell position formula ?

[banessa]

Hello,
How does one add cell positions?
For example, I am working with two worksheets. One has a list (ws2), the other (ws1) displays information from that list. I would like to display cell c3 from ws2 and in cell d5 in ws1, then display c4 from ws2 in cell d8 in ws1. I need these linked because I will have a lot of rows of this.
Thank you!!!!

[MarvinP]

Hi banessa and welcome to the forum,

See the attached example where I've done what I think you want.

[banessa]

Thank you for your quick reply.
What I'm trying to display is text, not data. I'm looking for something that will look something like this:
B3 in WS1= WS2!B2
B4 in WS1= WS2!B(2+1) so that it's actually B3...
This is really confusing to even try to describe. I've attached a sample of what I'm trying to do.

[MarvinP]

Hi,

This looks like you need to learn the Indirect Function.... See if this doesn't help at:
http://www.contextures.com/xlFunctions05.html