update column in VLOOKUP when columns are inserted

[Takeadoe]

Folks,

Is there a way to automatically change the column (where the data is to
come from) in the VLOOKUP function so that when a column is inserted
into the worksheet, the column in the VLOOKUP advances by 1? Of
course, the reverse would apply when a column is deleted.

Mike

 

[Don Guillett]

I think this is what you may want.
=VLOOKUP("a",A1:E5,COLUMN(C3))

 

[Takeadoe]

Folks,

Sorry to bother you. I went back and started digging around some more
and found my answer in the post below!

Thanks.

http://groups.google.com/group/micr...omatically+in+VLOOKUP&rnum=1#0f8ca81301384c35