VLOOKUP FORMULA?
 

A1 HAS A DROPDOWN LIST OF FIRST NAMES
HOW CAN I CORRELATED THIS LIST STEP BY STEP THAT WHEN
I SELECT ONE OF THE FIRST NAMES ON THE DROPDOWN AUTOMATICALLY
WILL FILL UP B WITH LAST NAME, C WITH PH NUMBER AND D WITH ADDRESS
FOR EACH INDIVIDUAL IN MY DROPDOWN LIST ( TOTAL OF 60 ). TX
PS: I RATHER NOT USE MACROS.

VLOOKUP FORMULA?
 

You have to first create a table with all this info.

Let's say on Sheet2 you have:

A1:A10 = first names
B1:B10 = last names
C1:C10 = phone number
D1:D10 = address

Your drop down is on Sheet1.

Enter this formula in Sheet1 B1:

=VLOOKUP($A1,Sheet2!$A1:$D10,COLUMNS($A:B),0)

Drag copy across to D1

Biff

"FC" wrote in message
...
A1 HAS A DROPDOWN LIST OF FIRST NAMES
HOW CAN I CORRELATED THIS LIST STEP BY STEP THAT WHEN
I SELECT ONE OF THE FIRST NAMES ON THE DROPDOWN AUTOMATICALLY
WILL FILL UP B WITH LAST NAME, C WITH PH NUMBER AND D WITH ADDRESS
FOR EACH INDIVIDUAL IN MY DROPDOWN LIST ( TOTAL OF 60 ). TX
PS: I RATHER NOT USE MACROS.

VLOOKUP FORMULA?
 

If the Last Name, PH Number and Address are in separate columns then VLOOKUP
is a possiblity BUT ONLY if the first name is unique.

How is the data (First name, Last name etc) organised?

"FC" wrote:

A1 HAS A DROPDOWN LIST OF FIRST NAMES
HOW CAN I CORRELATED THIS LIST STEP BY STEP THAT WHEN
I SELECT ONE OF THE FIRST NAMES ON THE DROPDOWN AUTOMATICALLY
WILL FILL UP B WITH LAST NAME, C WITH PH NUMBER AND D WITH ADDRESS
FOR EACH INDIVIDUAL IN MY DROPDOWN LIST ( TOTAL OF 60 ). TX
PS: I RATHER NOT USE MACROS.

VLOOKUP FORMULA?
 

That is exactly what I was looking for.Thanks T. Valko for your help. Also
thank you Toppers for getting interested in details about my questions. SYLA

"T. Valko" wrote:

You have to first create a table with all this info.

Let's say on Sheet2 you have:

A1:A10 = first names
B1:B10 = last names
C1:C10 = phone number
D1:D10 = address

Your drop down is on Sheet1.

Enter this formula in Sheet1 B1:

=VLOOKUP($A1,Sheet2!$A1:$D10,COLUMNS($A:B),0)

Drag copy across to D1

Biff

"FC" wrote in message
...
A1 HAS A DROPDOWN LIST OF FIRST NAMES
HOW CAN I CORRELATED THIS LIST STEP BY STEP THAT WHEN
I SELECT ONE OF THE FIRST NAMES ON THE DROPDOWN AUTOMATICALLY
WILL FILL UP B WITH LAST NAME, C WITH PH NUMBER AND D WITH ADDRESS
FOR EACH INDIVIDUAL IN MY DROPDOWN LIST ( TOTAL OF 60 ). TX
PS: I RATHER NOT USE MACROS.

VLOOKUP FORMULA?
 

You're welcome. Thanks for the feedback!

Biff

"FC" wrote in message
...
That is exactly what I was looking for.Thanks T. Valko for your help. Also
thank you Toppers for getting interested in details about my questions.
SYLA

"T. Valko" wrote:

You have to first create a table with all this info.

Let's say on Sheet2 you have:

A1:A10 = first names
B1:B10 = last names
C1:C10 = phone number
D1:D10 = address

Your drop down is on Sheet1.

Enter this formula in Sheet1 B1:

=VLOOKUP($A1,Sheet2!$A1:$D10,COLUMNS($A:B),0)

Drag copy across to D1

Biff

"FC" wrote in message
...
A1 HAS A DROPDOWN LIST OF FIRST NAMES
HOW CAN I CORRELATED THIS LIST STEP BY STEP THAT WHEN
I SELECT ONE OF THE FIRST NAMES ON THE DROPDOWN AUTOMATICALLY
WILL FILL UP B WITH LAST NAME, C WITH PH NUMBER AND D WITH ADDRESS
FOR EACH INDIVIDUAL IN MY DROPDOWN LIST ( TOTAL OF 60 ). TX
PS: I RATHER NOT USE MACROS.