C citygirl Jul 24, 2008 #1 How can I stop the table-array from changing when I drag-copy VLOOKUP down a sheet.
G Gord Dibben Jul 24, 2008 #3 Either use $ signs like $A$1:$D$52 Or give the range a defined name like TheTable through Insert>Name>Define Then the formula would be =VLOOKUP(G1,TheTable,2,FALSE) Gord Dibben MS Excel MVP
Either use $ signs like $A$1:$D$52 Or give the range a defined name like TheTable through Insert>Name>Define Then the formula would be =VLOOKUP(G1,TheTable,2,FALSE) Gord Dibben MS Excel MVP
