How would I....

B

Bruce

I have a worksheet that I created. I want to give it more flexibility.
I would like to refereace a cell from another sheet. But....
I would like to have a number in cell A3 that I can put in that would
control what row the info is being pulled from.

Ex: On current worksheet, I have cells B4 and B5 that have First and last
name. Lets call this WS1

On Worksheet 2, I have row for diffent clients. If I put the numer 3 in CELL
WS1:A3, then B4 will put the first name from the 3rd client on worksheet2

I would have something like =WorkSheet2!I2 if this is static, but I need to
replace the !I (row(a3)) and get it to be valid.

Help....

TIA
 
F

Frank Kabel

Hi Bruce
not quite sure I got it correctly but maybe INDIRECT is what you're
looking for
try in B4
=INDIRECT("'Worksheet2'!A" & A3)
for returning the value from column A, row(A3) from WS 2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
Integrating information from Word to Excel (not mail merge) 1
I need a cell to be blank. 4
Inequalities Function 3
How do I use the text content of a cell as a worksheet reference? 9
Find last cell in a column, Delete its contents and make it active 5
Development combinations with exclusion of columns 0
Development combinations with exclusion of columns 0

Top