Copying and pasting VLOOKUP formula

  • Thread starter Thread starter Garbhan
  • Start date Start date
G

Garbhan

I have a VLOOKUP Function:

=VLOOKUP(A2,'Execution Schedule'!C3:K2000,9, FALSE)

and this works perfectly in the second row of my worksheet. However
when I copy and paste this cell into the third and subsequent rows,
get the following:


=VLOOKUP(A3,'Execution Schedule'!C4:K2001,9, FALSE)

Both the lookup position (A2) and the table array (C4: K2000) ar
incremented by 1, but I want the table array to remain constant at th
original values.

I have tried entering the formula into the first few rows, selectin
them and dragging them down the column, but this doesn't work.

Any ideas?

Thank
 
=VLOOKUP(A2,'Execution Schedule'!C3:K2000,9, FALSE)

Just fix the table_array cell references in the above
i.e. make these absolute refs (with "$" signs)
before you copy the VLOOKUP down the col, viz.:

=VLOOKUP(A2,'Execution Schedule'!$C$3:$K$2000,9, FALSE)

It's a common error (happens to me too <g>)
 
Back
Top