0

I have a file with months names as sheet names like, January, february, march and so on. And one sheet named "overview". In total 13 sheets.

If in a cell of "overview" sheet it is written january then it will get data from "january" sheet like ='january'!A2. If the cell contains february then it will get data from "february" sheet like ='february'!A2.

Means cell in overview sheet have any month name and I want to get data from respective sheet.

Improve this question

1 Answer 1

Reset to default
0

You may use the indirect formula to convert a string to a reference. So, if cell A1 has the value say January which is also a name of the worksheet then you may enter a formula like =INDIRECT(A1 & "!A2") to pull value of cell A2 from January sheet. If the value in range A1 changes to February, the value will now be pulled from February sheet.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.