Hi, i'm not sure whether this is the right place to ask in regards to naming cells.

This is the problem...

I have a formula which is something like this
VLOOKUP($G35,monthdata1,COLUMN()+3-COLUMN($G35)),VLOOKUP($G35,alldata1,COLUMN()+1-COLUMN($G35))))

monthdata1 and alldata1 are name defined ranges.

the question is whether it's possible to swap this monthdata1 and alldata1 to monthdata2 and alldata2?

if not, is there other alternatives that i can do to produce the same effect?