Your first message said:

'---------------------------------
Then Sheets("Sheet1").Range("M1") = 4 :End

If the above is 4 or < 20 Then M1 = 5
If the above is 19 or < 120 Then M1 = 6
If the above is 119 Them M1 = 7
'------------------------------------

Now you don't want 4, 5 6 or 7 in M1 ?!?!?!

--
AP

"grahammal" a écrit
dans le message de
...

=VLOOKUP(L10,{0,4;5,5;20,6;120,7},2,1)
The above generates a 4,5,6 or 7 and is exactly what I wanted.

Next problem:-
Where the above generates the required number, I need to incorperate
that in the VLOOKUP table below.
=VLOOKUP(F10,'Mobile TRG Rate Card'!$A$2:$G$18,6,FALSE)*L10
It needs to take the place of the 6 entry which is the data column to
look at.
How can I insert the generated number into the table above.


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