update column in VLOOKUP when columns are inserted

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

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Takeadoe" <mtonkovich@msn.com> wrote in message
news:1144674331.433127.117960@j33g2000cwa.googlegroups.com...
> 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
>

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/micro...8ca81301384c35