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