Hi All.

Say, for example, I have a few columns in Excel 97 (Name, Address 1, Address 2, Telephone number, etc, etc.) and it's always the same three or four persons' details which I input every time, for which I have created a drop down list for the names of the people. How can I make Excel automatically complete the remainder of the row (address, tel no, etc) as soon as I click the drop down arrow and select a name from the Name column?

Thanks.

The only way that I can think of doing it would be using if/then statements. For example:


=IF(A1="Bob","101 Main St")

After giving this a little thought, you'd need to use nested IF statements for what you're trying to accomplish. For example:


=IF(A1="Bob","101 Main St",IF(A1="John","25 Daisy Ln",IF(A1="Bill","50 Rose Dr")))

If you enter the above formula in cell A2, you'd get the appropriate address depending on the name you enter in A1.

Entering Bob will give you 101 Main St
Entering John will give you 25 Daisy Ln
Entering Bill will give you 50 Rose Dr

However, I believe Excel limits you to 7 nested IF statements.

The above formula will give a False value if A1 is left blank. A way around that is to add a comma and a couple quotes at the end of the formula as follows:


=IF(A1="Bob","101 Main St",IF(A1="John","25 Daisy Ln",IF(A1="Bill","50 Rose Dr","")))

Thanks Scuzzy! I am playing with it.

Is it the same for the XP version? Does XP have a limit of 7 as well?

Thanks.