"sedonovan" wrote:
.. but what about information I need to store in B3...Bx?
Ah, then it's easier to use data validation ..
Assuming the same setup, viz.: names & initials in Sheet1's A1:B3
Select A1:A3, and name the range as: Name
(via: Insert Name Define)
Then in Sheet2,
Select the range say, A2:A20
Click Data Validation, make the settings:
Allow: List
Source: Name
Click OK
Then put in B2, and copy down to B20:
=IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0))
Col B will extract the initials for the names selected in col A
Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---