Hi,

just realised I can actually combine your formula with the formula =Ceiling.

Thanks!
Val

"PC" wrote:

One way

With your table starting in A1

=OFFSET(A1,MATCH(5,A1:A3,0)-1,MATCH("256k",A1:D1,0)-1)

You can also simplify this a little by allowing the user to input the
figures without the "k" by using a custom format that puts a "k" at the end
of the number (I'm pretty sure it would be #k) Just make sure you set up
the row headers the same way so the inputs (256 in both cases) are
identical.

HTH

PC

"Dolphinv4" wrote in message
...
Hi,

I have a table as follows:
(Speed)
(Dist) 64k 128k 256k
5 1000 1200 1500
10 1600 1700 1800
15 2000 2100 2200

I'd like to have a formula whereby if I key in a Distance of 4 and a speed
of 256k, the active cell will show "1500".

I tried to use sumproduct but seems like sumproduct can only be used if
the
Dist is exactly "5", "10", etc. The only alternative I can think of is to
list out ALL the integers for Distance. But, is there an easier way?

Thanks,
val