Your reply solves my original problem fine thankyou and will put a 4,5,6
or 7 in column M1.
What I have done is populated all of the M column from row 1 down to
100 with this formula.
So now we have column M full of numbers from 4 to 7.
The folowing table is going to be in column P:-
=VLOOKUP(F1,'Mobile TRG Rate Card'!$A$2:$G$18,6,FALSE)*L1

What I need is the number that appears in column M to be incorperated
in the above table so it looks like:-
=VLOOKUP(F1,'Mobile TRG Rate Card'!$A$2:$G$18,column M,FALSE)*L1
I have used:-
=VLOOKUP(F1,'Mobile TRG Rate Card'!$A$2:$G$18,$M$1,FALSE)*L1
This works fine but when I try to populate rows 1 to 100 with it, the
F1 & L1 increments to F2 & L2 OK but the $M$1 stays the same?
I want it to increment on to $M$2.
Thats my problem.
PS your working wonders so far.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=520529