Forum Discussion
how to get a cell value from a sheet to be entered on another sheet
Hi,
I'm new to excel, and I'm trying to understand how to get the value from cell B2 from sheet 1, for example, to be used on sheet 2. What do I type in the value on sheet 2, cell C3, for example, so that the value from cell B2 from sheet 1 is 'pulled over'?
Any help from you young smart people would be greatly appreciated! 🙂
Greg
=INDIRECT("'"&C2&"'!"&C1)
Maybe with the above formula which is in cell C3 of sheet2 in the attached example.
If you want to dynamically pull data from a cell in another sheet you can enter the sheetname in cell C2 (e.g. sheet1) and the cell in C1 (e.g. B2).
2 Replies
=INDIRECT("'"&C2&"'!"&C1)
Maybe with the above formula which is in cell C3 of sheet2 in the attached example.
If you want to dynamically pull data from a cell in another sheet you can enter the sheetname in cell C2 (e.g. sheet1) and the cell in C1 (e.g. B2).
- Thx Q Pawn!
Greg
