Looking for a formula to look up data - Not vlookup

[Nick]

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

 

[Bernie Deitrick]

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]

This was somewhat helpful, but I couldn't get the two "match" formula's to work

 

[Bernie Deitrick]

Nick,

Sometimes, it helps to post what you tried. Often, the MATCH can be cured by
using False as the third parameter to force an exact match.

HTH,
Bernie
MS Excel MVP

 

[Nick]

I got it to work. I used hlookup instead and got the desired result

thanks for the help

Nick