VLOOKUP

[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?

 

[michael]

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

 

[Dan E]

Bridget,

In your formula put $A$7:$E$392 instead of A7:E392

Dan E

 

[Paul]

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?

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