In a table array on a summary, one column has dates in the format YYYYMMDD. I also have sheets named in the same format. I want to use the date in the summary sheet to steer the formula to the relevant sheet to perform lookups and counts, but am unable to get the formula structure correct. Can you offer a solution?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using a label to direct a formula to a sheet
- Thread starter MarcB
- Start date
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
Have a look at the INDIRECT function.
Upvote
0
Similar threads
- Question
- Question
