Use Absolute addressing as in


=VLOOKUP(F1,$A$1:$E$1,3,FALSE)

F1 is relative and increments as you drag down the column.

The table references do not change.


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 11:59:01 -0700, rebdk
wrote:

How do you maintain the cell references for the lookup table when copying the
function to additional cells?