formula linked to another sheet when the sheet name is in a cell

[skf786]

Hello,

i want to add a vlookup (or any other formula) where the data is in multiple other sheets (sheets named, jan, feb, mar..... ) and the value to be picked up would depend on the sheet name which is dynamic, based on cell A1 in sheet named main. So if a user selects 'Jan' in cell A1, the file would vlookup the value in sheet named Jan.

thank you in advance!

regards,

Khalid

 

[RoryA]

You need the INDIRECT function - something like INDIRECT("'"&Main!A1&"'!A1:G1000") for example.

 

[skf786]

You need the INDIRECT function - something like INDIRECT("'"&Main!A1&"'!A1:G1000") for example.

that is awesome! works perfectly with my vlookup

thanks Rory!