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