S sabrina Jul 31, 2008 #1 Can I fix the range of table array, so when I copy and paste vlookup formula, the table array can be kept in an original range.
Can I fix the range of table array, so when I copy and paste vlookup formula, the table array can be kept in an original range.
P Pete_UK Jul 31, 2008 #2 Yes, you need to use absolute addressing by putting $ in front of the cell references for the table. For example, your formula might look like this: =VLOOKUP(A1,$M$1:$P$100,2,0) Then you can copy it down and the $M$1:$P$100 will not change. Hope this helps. Pete
Yes, you need to use absolute addressing by putting $ in front of the cell references for the table. For example, your formula might look like this: =VLOOKUP(A1,$M$1:$P$100,2,0) Then you can copy it down and the $M$1:$P$100 will not change. Hope this helps. Pete
