Lookup reference help
 

Hi Folks,

I have a sheet, where the contents of cell A1 is a result of other
criteria being met. For the purpose of this example, the result in A1
is "Oral Health"

In cells B1 thru to W1 are column headers, one of which will match the
result in A1 (Oral Health is E1, Population Health is K1, etc).
Under each of these header cells are seven or eight cells with a range
of vehicles (B2-B9 thru W2-W9 respectively)

What I am trying to do is create a custom list of vehicles so that if
A1 = Oral Health, and the Oral Health header is E1, I'd like the
contents of E2 - E9 to fill cells A2 to A9. That way the Oral Health
vehicles become the focus of a drop down box on another related sheet.

Everything but this lookup reference is working, and not sure how to
apply the correct lookup.

Any help greatly appreciated

TIA

Pete

Lookup reference help
 

Try this...

Entered in A2 and copied down to A9:

=INDEX(B$2:W$9,ROWS(A$2:A2),MATCH(A$1,B$1:W$1,0))

--
Biff
Microsoft Excel MVP


"DubboPete" wrote in message
...
Hi Folks,

I have a sheet, where the contents of cell A1 is a result of other
criteria being met. For the purpose of this example, the result in A1
is "Oral Health"

In cells B1 thru to W1 are column headers, one of which will match the
result in A1 (Oral Health is E1, Population Health is K1, etc).
Under each of these header cells are seven or eight cells with a range
of vehicles (B2-B9 thru W2-W9 respectively)

What I am trying to do is create a custom list of vehicles so that if
A1 = Oral Health, and the Oral Health header is E1, I'd like the
contents of E2 - E9 to fill cells A2 to A9. That way the Oral Health
vehicles become the focus of a drop down box on another related sheet.

Everything but this lookup reference is working, and not sure how to
apply the correct lookup.

Any help greatly appreciated

TIA

Pete

Lookup reference help
 

On May 10, 12:29*pm, "T. Valko" wrote:
Try this...

Entered in A2 and copied down to A9:

=INDEX(B$2:W$9,ROWS(A$2:A2),MATCH(A$1,B$1:W$1,0))

--
Biff
Microsoft Excel MVP

"DubboPete" wrote in message

...



Hi Folks,

I have a sheet, where the contents of cell A1 is a result of other
criteria being met. *For the purpose of this example, the result in A1
is "Oral Health"

In cells B1 thru to W1 are column headers, one of which will match the
result in A1 (Oral Health is E1, Population Health is K1, etc).
Under each of these header cells are seven or eight cells with a range
of vehicles (B2-B9 thru W2-W9 respectively)

What I am trying to do is create a custom list of vehicles so that if
A1 = Oral Health, and the Oral Health header is E1, I'd like the
contents of E2 - E9 to fill cells A2 to A9. *That way the Oral Health
vehicles become the focus of a drop down box on another related sheet.

Everything but this lookup reference is working, and not sure how to
apply the correct lookup.

Any help greatly appreciated

TIA

Pete- Hide quoted text -

- Show quoted text -

Thanks Biff
works a treat
job fixed!

Pete

Lookup reference help
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DubboPete" wrote in message
...
On May 10, 12:29 pm, "T. Valko" wrote:
Try this...

Entered in A2 and copied down to A9:

=INDEX(B$2:W$9,ROWS(A$2:A2),MATCH(A$1,B$1:W$1,0))

--
Biff
Microsoft Excel MVP

"DubboPete" wrote in message

...



Hi Folks,

I have a sheet, where the contents of cell A1 is a result of other
criteria being met. For the purpose of this example, the result in A1
is "Oral Health"

In cells B1 thru to W1 are column headers, one of which will match the
result in A1 (Oral Health is E1, Population Health is K1, etc).
Under each of these header cells are seven or eight cells with a range
of vehicles (B2-B9 thru W2-W9 respectively)

What I am trying to do is create a custom list of vehicles so that if
A1 = Oral Health, and the Oral Health header is E1, I'd like the
contents of E2 - E9 to fill cells A2 to A9. That way the Oral Health
vehicles become the focus of a drop down box on another related sheet.

Everything but this lookup reference is working, and not sure how to
apply the correct lookup.

Any help greatly appreciated

TIA

Pete- Hide quoted text -

- Show quoted text -

Thanks Biff
works a treat
job fixed!

Pete