INDIRECT in VLOOKUP with sheet named by date (MM/DD/YYYY) - syntax error
I am having trouble using INDIRECT to pass a columns-range into VLOOKUP.
VLOOKUP(AD2, INDIRECT(AC$1 & "::" & "Table 1" & "::" & "$B:$C"), 2, exact match)
AC$1 = “12/28/2024”, manually typed and formatted as a Date (MM/DD/YYYY)
When defined using the formula bar, the range is named 12/28/2024::Table 1::$B:$C
The exact same syntax works properly for SUM or COUNT,
but when pasted into the columns-range of a (properly functioning) VLOOKUP formula, it creates a syntax error.
Am I overlooking some obvious error?
Thank you!
iPad, iOS 10
