ManCityPete
New Member
- Joined
- Oct 30, 2015
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet with tabs for each month. On each worksheet I have created a named range, the name being based around the year and month. Each range has an entry for each day so 28-31 entries.
On a summary sheet, I want to use a vlookup formula to pull in the data from each month's sheet.
I can create the formula manually easily... =VLOOKUP(A1,+May_21,3,FALSE)
But this means I have to manually go down the list and create a separate formula for each month. So I can set B1 to produce May_21, but when I try VLOOKUP(A1,+B1,3,FALSE) it just returns an #VALUE! error.
It's easy for me to automatically generate the range name I want to look at, but how do I build that automatically into the VLOOKUP formula?
On a summary sheet, I want to use a vlookup formula to pull in the data from each month's sheet.
I can create the formula manually easily... =VLOOKUP(A1,+May_21,3,FALSE)
But this means I have to manually go down the list and create a separate formula for each month. So I can set B1 to produce May_21, but when I try VLOOKUP(A1,+B1,3,FALSE) it just returns an #VALUE! error.
It's easy for me to automatically generate the range name I want to look at, but how do I build that automatically into the VLOOKUP formula?