Lookup reference help

[DubboPete]

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

 

[T. Valko]

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))

 

[DubboPete]

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











- Show quoted text -

Thanks Biff
works a treat
job fixed!

Pete

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

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











- Show quoted text -

Thanks Biff
works a treat
job fixed!

Pete