Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rookie q
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rookie q
=VLOOKUP(A1,Sheet1!A1:D10,2,False)
and change the index number for each field. -- HTH ------- Bob Phillips "C3" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rookie q
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 -- Regards, Tom Ogilvy "C3" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rookie needs help | Excel Worksheet Functions | |||
Rookie needs help! | Excel Discussion (Misc queries) | |||
Rookie needs a macro | Excel Worksheet Functions | |||
Rookie q | Excel Worksheet Functions | |||
Help for a VBA rookie | Excel Programming |