C

#### Carolina

(header) to row 199.

For a plain example I want to use hlookup to look up the number in column CA

and return the value from the column containing the same number. I.e. I want

the result to for the 5 lookup to be $1,575.

CA DV DW DX DY DZ

5 $275 $550 $825 $1,200 $1,575

I managed to pull the following formula and it works

=HLOOKUP(CA4,$DV$3:$EE$199,2,FALSE)

....but now I want to drag it to all subsequent rows but when I do the 2

stays the same....it should be 3, 4, 5, and so on....is there a way of

automatically dragging the formula to the following rows taking the

respective row data?