Is there a way to use a variable for the table_array in a VLOOKUP, specifically, where the table_array is in another
workbook? I'm not afraid to use a VBA function if necessary but it'd be nice to have the function all 'self-contained' using
standard formula commands.
This is an example of what I'm looking to do:
ADJUSTED.xls!MinMax",ClothingType), 22 + GenderOffset, FALSE)
Since a string is returned, this function fails. I'm guessing I need a Range returned?
"CONCATENATE("..." part is the piece causing me the issue. Depending upon what Form (radio) button the user
clicks (that part is done), the table_array range will change.