Sorry Kevin!

You are going to love me!

Is there a way in which you can make Excel work out what you're doing
when you copy formula down rows?

For example, I currently have this as my first formula:

=IF(B9="Truckstop1",J3,IF(B9="Truckstop2",J4,""))

Which basically works out which truckstop name I've typed in & then
copies across the relevant haulage rate.

Unfortunately, when I do the drag/copy thing, it does the usual Excel
pre-guessing you:

=IF(B9="Truckstop1",J3,IF(B9="Truckstop2",J4,""))
=IF(B10="Truckstop1",J4,IF(B10="Truckstop2",J5,"") )
=IF(B11="Truckstop1",J5,IF(B11="Truckstop2",J6,"") )

Basically, I want the above B column cells to increase by 1 each time,
but I still need it to refer to cells J3 or J4 each time, rather than
increasing accordingly.

Is this possible? Sorry to be a pain!

Thanks

Leo Edwards