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?
Bookmarks