VLOOKUP

  • Thread starter Thread starter Bridget Stacy
  • Start date Start date
B

Bridget Stacy

I am using the VLOOKUP function to compare values from one
table to values in another table. I inserted the VLOOKUP
function into one cell and it works fine. When I try to
drag the formula down to compare all the values, the
table_array value keeps changing (ie - the table is
located at A7:E392, but when I drag the formula down to
the next cell, it changes the table_array to A8:E393).
How do I get the table_array value to remain constant?
 
Make the cell reference absolute like this $A$7:$E$392,
you can get the $ sign to go on automatically when writing
the formula by using the F4 key

Happy Christmas
Michael
 
Bridget Stacy said:
I am using the VLOOKUP function to compare values from one
table to values in another table. I inserted the VLOOKUP
function into one cell and it works fine. When I try to
drag the formula down to compare all the values, the
table_array value keeps changing (ie - the table is
located at A7:E392, but when I drag the formula down to
the next cell, it changes the table_array to A8:E393).
How do I get the table_array value to remain constant?
Click to expand...

Use absolute addresses for the table. That is, change A7:E392 to
$A$7:$E$392.
 
Back
Top