I am having a huge database in Excel and use all possible formulas to manage the reports. One formula I frequently use is "=IF(ISNA(VLOOKUP($B19,[Book1.xls]GR'!$B$26:$Q$92,3,0)),0,VLOOKUP($B19,[Book1.xls]GR'!$B$26:$Q$92,3,0))". My problem is that I have to copy the formula in every column and than change the column No. manually. Is there any way to make Excel understand to update the Col Index No on every change? It will save a lot of time as well as energy.