Hi I have been trying to figure out how to create a dynamic table array for my vlookup that references a different workbook. I would like the sheet name to be dynamic using a specific cell value from the original workbook. Each sheet is saved as a date in mm dd yyyy format. I would like to replace the 01 08 2022 with cell (D2) Is this be possible to do? I have gotten errors every way I've tried and am stumped!
=VLOOKUP(A2,'[FC YTD.xlsm]01 08 2022'!$A:$AZ,37,0)
=VLOOKUP(A2,'[FC YTD.xlsm]01 08 2022'!$A:$AZ,37,0)