Lists / Menus

  • Thread starter Thread starter Scott R
  • Start date Start date
S

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
 
.. 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..
Click to expand...

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

---
 
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?
 
Afraid I'm out of better ideas to offer you. But do hang around awhile for
possibilities from other responders
 
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
 
Thanks guys.. Ill back and see exactly what I need to do and go from there.
Thanks for your help :)
 
Back
Top