vlookup

[sabrina]

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.

 

[Pete_UK]

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