Nick,

You need to match on something else as well - date, probably - for the
horizontal match, and then some criteria for a vertical match. If you
describe that, we could probably get the data point using INDEX(Table,
MATCH(VertValue,,...), MATCH(HorizValue,,,...))

HTH,
Bernie
MS Excel MVP


"Nick" wrote in message
...
my data table is as follows:

16-Jun-09 29-May-09 15-May-09 28-Apr-09 7-Apr-09
Slow Slow Slow Dead Dead
1000 1200 1000 1050 1100
0:16.565 0:19.553 0:16.252 0:17.707 0:18.860
0:15.627 0:19.063 0:15.701 0:16.510 0:17.428
0:15.759 0:19.002 0:15.649 0:16.605 0:17.810
0:16.158 0:18.886 0:15.218 0:16.694 0:18.684
1:04.109 1:16.504 1:02.820 1:07.516 1:12.782
56.15 56.47 57.31 55.99 54.41

I am after something that will look up data vertically so if I put in
"Slow"
it will then look up all the "Slow" columns. I tried using lookup but
couldn't get it to work and vlookup only works for one value as far as I
can
tell