Lists / Menus

[Scott R]

Hi Guys, I have a drop down list (that looks at another worksheet) and I
select their first name, I then want another cell to automatically bring up
that persons surname.. Is there some kind or sub menu or list I use?.. Ive
gone into all my usual websites (pearsons, contextures etc) but dont really
know what im looking for, any help would be great...
Scott

 

[Max]

.. I have a drop down list (that looks at another worksheet)

and I select their first name,
I then want another cell to automatically bring up that persons surname..

A formulated col using say, index/match would do that for you
Eg In Sheet1, if DVs in A2 down,
you could have something like this in B2 down:
=IF(A2="","",INDEX(Sheet2!A:A,MATCH(A2,Sheet2!B:B,0)))
where cols A and B in Sheet2 holds the surnames & firstnames

 

[Scott R]

Are there any other ways? I have several lists on the one worksheet that need
to 'autofil'. Can it be done without a formulated col?

 

[Max]

Afraid I'm out of better ideas to offer you. But do hang around awhile for
possibilities from other responders

 

[Gord Dibben]

VLOOKUP function will also fill the cells but that is "formulated"

Without formulas you would have to resort to VBA event code


Gord Dibben MS Excel MVP

 

[Scott R]

ok thanks for that

Afraid I'm out of better ideas to offer you. But do hang around awhile for
possibilities from other responders

 

[Scott R]

Thanks guys.. Ill back and see exactly what I need to do and go from there.
Thanks for your help