Hi, I wanted to ask a question that probably many have asked before, and I'm hoping there's an answer. When one copies a vlookup across columns, is there a way to do this and manitiant the lookup value cell but change the Col_index_Num consecutively (eg. lookup value $A$2, table array remains fixed, clomun moves 2,3,4,5,6 etc. ) thanks in advance.