Lists / Menus
 

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

Lists / Menus
 

.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Lists / Menus
 

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" wrote:

.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Lists / Menus
 

Afraid I'm out of better ideas to offer you. But do hang around awhile for
possibilities from other responders
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Scott R" wrote in message
...
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?

Lists / Menus
 

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

On Wed, 6 Feb 2008 12:48:01 -0800, Scott R
wrote:

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" wrote:

.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Lists / Menus
 

ok thanks for that :)

"Max" wrote:

Afraid I'm out of better ideas to offer you. But do hang around awhile for
possibilities from other responders
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Scott R" wrote in message
...
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?

Lists / Menus
 

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

"Gord Dibben" wrote:

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

On Wed, 6 Feb 2008 12:48:01 -0800, Scott R
wrote:

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" wrote:

.. 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---