Extending a formula series but fixing part of it.

[dan_pafc]

I know this must be quite simple but im not sure now to do it.

Ive got a Lookup formula like =LOOKUP(A1,B1:B5,C1:C5), and want to extend the series but so that A1 changes to A2, A3, A4 etc as i drag it down, but i want to keep tha B1:B5,C1:C5 without it changing to B2:B6,C2:C6 etc.

If someone can tell me how to do it please.

Thanks

Dan.

 

[goldfish]

Put a $ in front of anything that you don't want to change. So here you don't want the numbers to change so you would use:

=LOOKUP(A1,B$1:B$5,C$1:C$5)

If you didn't want some of the columns to change as you were dragging accross you could use $ in front of some of the letters like this:

=LOOKUP(A1,$B$1:$B$5,$C$1:$C$5)

HTH,
~Gold Fish

 

[dan_pafc]

Cheers GFish,

R+R

Dan.