Thread: LISTS
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default LISTS

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