Either use $ signs like $A$1:$D$52

Or give the range a defined name like TheTable through InsertNameDefine

Then the formula would be =VLOOKUP(G1,TheTable,2,FALSE)


Gord Dibben MS Excel MVP

On Thu, 24 Jul 2008 13:14:08 -0700, citygirl
wrote:

How can I stop the table-array from changing when I drag-copy VLOOKUP down a
sheet.