Monster XL Question

[vtec]

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.

[Colin Legg]

Welcome to the forum. You need to use INDIRECT() - see attached example.

[vtec]

Top work! Thanks so much!