Paul,
Thank you for your patience . . . I now see it!
Steve
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Paul Schreiner
Sent: Sunday, November 26, 2017 9:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup variable
Are you trying to look up the date from J1?
If so, wouldn't it be:=VLOOKUP($J$1,INDIRECT("'"&E2&"'!"&"$A$3:$F$3"),5,0)
and, I'd suggest changing $F$3 to something like $F$1000
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
