Rookie q

[C3]

How to fill other cell with data from in-cell list?

Example data:
Worksheet 1

A B C D
1 John Street 2 NY
2 Mike Street 3 TX


Worksheet2:

A
1 "In-cell list for data in worksheet1 - list(John, Mike)" For example I
choose John

Then fill cells

A
5 Street
6 2
7 NY

 

[Bob Phillips]

=VLOOKUP(A1,Sheet1!A110,2,False)

and change the index number for each field.

 

[Tom Ogilvy]

for the in-cell list part, create a defined name
Insert=>Name=>Define

Name: List1
Refersto: =Sheet1!$A$1:$A$2

Then in the cell A1 on worksheet2, do Data=>Validation, select the list
option and in the box put

=list1