I am trying to run a VLookup across 19 tabs. The formula and result are below
=Vlookup(2255099,INDIRECT("'"&CENTERS&"!A5:R395""),13,0) returns a #VALUE
When I evaluate the formula, the result is:
=Vlookup(2255099,INDIRECT("'"&#VALUE&"!A5:R395""),13,0)
Does the #VALUE where CENTER was mean there is a problem with my Named Range?
Thanks.
Bookmarks