- May 23, 2005
- Office Version
I have a table consisting of roughly 20 columns. In a worksheet i have a formula which contains a VLOOKUP. My table array within my VLOOKUP is the same as my aforementioned table, however when I add a column to my table the VLOOKUP formula no longer works. Isn't this what creating a table is supposed to achieve? I thought creating the table would allow me to create and add columns without it affecting my formulas?