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

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

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

"Bernie Deitrick" wrote:

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

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" wrote in message
...
This was somewhat helpful, but I couldn't get the two "match" formula's to
work

"Bernie Deitrick" wrote:

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

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

thanks for the help

Nick

"Bernie Deitrick" wrote:

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" wrote in message
...
This was somewhat helpful, but I couldn't get the two "match" formula's to
work

"Bernie Deitrick" wrote:

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