Hi all,

i'm trying to construct a formula that will look like this in excel
=vlookup(O4,Month_A&"_A",2, false)

Month_A (R2) contains a drop-down data validation with a list of months
the user selects the month and then the formula takes that
appends _A to it
and that will be the name of the range it will lookup in

doing it the way i am, produces a string that apparently excel doesn't like,
or know what to do with.

is there a way to convert the string back to a reference that excel will
understand?

tia

J