vlookup

S

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.
 
P

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
 
Top