Sweedler
Board Regular
- Joined
- Nov 13, 2020
- Messages
- 114
- Office Version
- 2016
- Platform
- Windows
- MacOS
Hello all
I have an interesting conundrum.
I have a document with about 20 sheets and want a Vlookup on one of them that searches all the others. My thought was to create a little sub-sheet that gives me the name of the sheet based on the cell value that dictates which sheet to search. But I can’t figure out how to incorporate a cell value into my vlookup “range”.
Does anyone know how to do this?
I’m open to other ideas for how to do the multiple sheet vlookup as well.
Thank you
I have an interesting conundrum.
I have a document with about 20 sheets and want a Vlookup on one of them that searches all the others. My thought was to create a little sub-sheet that gives me the name of the sheet based on the cell value that dictates which sheet to search. But I can’t figure out how to incorporate a cell value into my vlookup “range”.
Does anyone know how to do this?
I’m open to other ideas for how to do the multiple sheet vlookup as well.
Thank you