dynamic naming cells

[excelsmu]

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?

[VBA Noob]

I assume you have two named ranges 1 and 2.

Then try something like

INDIRECT("alldata"&ROW(A1))

VBA Noob

[excelsmu]

thanks! that's very useful