=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