Anne Troy wrote:
That's why I always use named ranges for my vlookups (whenever reasonable to
do so), as described he
http://www.officearticles.com/excel/...soft_excel.htm
But you need to reference absolutely your table:
=VLOOKUP(A2,'sheet2'!$A$1:$A$510,1,FALSE)
:)

Ahh, the dollar signs for absolute, that's what I needed. Thanks!