changing array in vlookup

[jc.shapiera]

I need to add a changeable array in a vlookup formula. I have been
working with the following to no avail:
VLOOKUP(VALUE,TEXT("ABC"&"_"&X49,),column, range). I have multiple
arrays in the format of ABC_"MONTH"_"YEAR" and the reference cell
(X49) needs to change month by month.
The formula TEXT("ABC"&"_"&X49,) on its own does work and returns
ABC_MNTH_YR but when inserted into the vlookup formula returns a
#value error. Any help appreciated.
J.