How do I get a cell value using another cells value

G

Guest

I have multiple worksheets. I want to get a cells value from one worksheet
based on the cell value of another
E.g. Worksheet 1 Cell reference A1 contains B298
I want on worksheet 1 in cell reference A2 to contain the value in worksheet
2, Cell reference B298

Regards
Chris
 
A

Andibevan

Chris,

put in cell a2 =indirect(a1)

HTH

Andi

I have multiple worksheets. I want to get a cells value from one worksheet
based on the cell value of another
E.g. Worksheet 1 Cell reference A1 contains B298
I want on worksheet 1 in cell reference A2 to contain the value in worksheet
2, Cell reference B298

Regards
Chris
 
B

Bob Phillips

Slight mod

=INDIRECT("Sheet2!"&A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Yes you are missing the fact that A1 might change to C298


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Excel VBA 1
Find and replace a value within a formula 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cell reference value to remain constant in a sort using Paste Link 2
Cell reference between worksheets 4
Using cell as worksheet reference (macro) 1
Value used in a Paste Link to remain constant during a sort 1
Code to format cells on several worksheets 2

Top