Slight mod
=INDIRECT("Sheet2!"&A1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Andibevan" wrote in message
...
Chris,
put in cell a2 =indirect(a1)
HTH
Andi
"Chris" wrote in message
...
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
|