Can you 'fix' an array of values for use with VLOOKUP

  • Thread starter Thread starter mavisB
  • Start date Start date
M

mavisB

I would like to use VLOOKUP to reference a set of data. When I paste the
formula using 'Fill Down' the array values change.

Is there a way to fix the array?

Should I use a different function or is there a way to manipulate the Fill
Down function?
 
Make the reference absolute so by using the '$' so that it doesn't change
when the formula is copied.
ie: =VLOOKUP(E2,$A$2:$B$5,2,FALSE) instead of
=VLOOKUP(E2,A2:B5,2,FALSE)
 
You can also give the table array a defined name.

=VLOOKUP(A1,myname,2,FALSE)


Gord Dibben MS Excel MVP
 

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

Vlookup with a pick list for tables 1
Extract multiple values from array 2
Use array for lookup value, to return array of lookups 4
VLOOKUP #REF error 3
Array Function to do a Sum of VLookUps that translate a letter gra 3
replace all formulas with values in multiple worksheets 5
Array VLOOKUP lookup_Value does not increment 3
Vlookup 3

Back
Top