On Monday, May 14, 2018 at 9:29:39 PM UTC-4, wrote:
Vlookup - Sheet Name in Cell

I have created a cell with all of the tab names within that spreadsheet. I want to use vlookup such that the sheet name will be in the referenced cell. I also need to know how to include the sheet range?

ex. vlookup(A1,(sheet named in cell-including range),5,false).

Update: I've simplified this such that there are two sheets used for the vlookup with the same range. Hence all I need it to do is to something like this:

vlookup(A1,'PROS All'!A:Z,5,false) ***I would only need to change the sheet name from 'PROS' to 'CONS' by referencing another cell to get the difference in the sheet name.