vlookup

  • Thread starter Thread starter sabrina
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I insert a dynamic reference of a range inside VLOOKUP? 4
Vlookup error 1
Linked Named Ranges 2
Use & with two formulas 2
Vlookups not working 2
VLOOKUP & non-contiguous table array 3
VLOOKUP -- Table Array Problem 1
Nested functions using array/range names 3

Back
Top