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

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

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

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?

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?

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

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