I have a data base set up in Excel that records all manor of information. I
then use "Vlookup" to extract information into different tabs of the
spreadsheet.

Ie) to one tab provides the summary of the address.

The problem that I have is that if we introduce another column to the data
base the "Col_index_number" on the Vlookup does not automatically update. Ie)
the information that you wanted to look up use to be in Column 6, but once
you inserted another cell it is now in column 7, but the lookup is still
refering to Column 6.

Is there a way around this.
Michael