Hi Larry,
You may want to also post this in the MS Office Excel discussion group through the links below and when posting there please also
include the version of MS Excel you're working with.
================
I do many Vlookups and I copy this formula over 20 columns. Can the
Col_Index_num increment automaticaly. Currently I have to modify each
cell.

>>
--
Please let us know if this has helped,
Bob Buckland ?

MS Office System Products MVP
LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel
B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com