Excel 2003

[SchizJoe]

I am trying to make multiple copys of a function i wrote to go down an entire
column

L | M | N
-----------------------------------------------------|
|
2 | KY | =lookup(L2,v2:w63) | |
3 | NJ | =lookuo(L3,v2:w63) | |
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
This is what i want the drag and copy to do....|
-----------------------------------------------------|

Below is what i get

L | M | N
-----------------------------------------------------|
|
2 | KY | =lookup(L2,v2:w63) | |
3 | NJ | =lookuo(L3,v3:w64) | |
|
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
This is what i get with the drag and copy |
-----------------------------------------------------|

My question is this is it possible to do what i want so that i dont have to
retype the formula in column M for each new row.

 

[TomPl]

Change:
2 | KY | =lookup(L2,v2:w63) | |
To:
2 | KY | =lookup(L2,$v$2:$w$63) | |

That should work.

Tom