The formula looks like this =LOOKUP($C16,Emissions!B4:B31)

$C16 has a value of 116 which should return a value of 12, however i
looking down the table and choosing 11. So its rounding down to th
whole number, I need it to round up.

Chart

g/Km - Elec/Petrol
0 - 6
25 - 7
45 - 8
65 - 9
85 - 10
105 - 11
125 - 12


Any better

--
Odysseu
-----------------------------------------------------------------------
Odysseus's Profile: http://www.excelforum.com/member.php...fo&userid=1456
View this thread: http://www.excelforum.com/showthread.php?threadid=26195