Lookup reference help

D

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

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top