Monster XL Question
Right. Deep breath.
I'm in the process of writing a monster spreadsheet and have hit a pretty vertical wall.
It is composed of 5 sheets.
On the main sheet, I need a formula that autofills cells.
I want to be able to enter either RDL 0035, RDS 009, RDS 007 or RDL 002 into cell G1. These are the names of the other 4 spreadsheets.
Depending on what text is entered into main sheet, cell G1, the values in main sheet, J2:K17 change to the values of J2:K17 from the sheet that is named in cell G1.
I believe I need to use VLookups?
Is this even possible?
Thanks.
|