VLOOKUP FORMULA?

[Guest]

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.

 

[T. Valko]

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
D110 = 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

 

[Guest]

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?

 

[Guest]

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]

You're welcome. Thanks for the feedback!

Biff

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