I'm trying to do a vlookup (in a cell, not VBA) where the range is determined by a variable stored in another cell.
=VLOOKUP(TRIM(A3)&"*",'\\030-DC1\Company$\ADOE 30\re-entry calc\[ReEntry Calculations.xlsx]August 13'!$A$2:$N$150,6,0)That is the lookup without the variable. It works great.
I...