Automatically populate one cell based on information from another cell using dropdowns

**gr8teful** · 03-04-2024, 08:30 PM

HI
I've just joined and would love some help.
In NUMBER2 worksheet I have a list of 100 clients and their addresses. Name in A1, Address in B1 and City in C1
In NUMBER1 work sheet I want to be able to select a name of a client from a dropdown list created from NUMBER2 worksheet A1. Immediately after that I'd like the next 2 cells, let's say A2 and A3 to automatically populate with the relevant information of the address and the city of that client.

Can it be done?
Any help very much appreciated.

**TMS** · 03-04-2024, 08:34 PM

Clear the expected results and try this:

Formula:

Please Login or Register  to view this content.

**gr8teful** · 03-04-2024, 10:29 PM

Absolutely magic. Thank you very much.

**TMS** · 03-05-2024, 01:13 AM

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Automatically populate one cell based on information from another cell using dropdowns

LinkBack

Thread Tools

Rate This Thread

Display

Automatically populate one cell based on information from another cell using dropdowns

Re: Automatically populate one cell based on information from another cell using dropdowns

Re: Automatically populate one cell based on information from another cell using dropdowns

Re: Automatically populate one cell based on information from another cell using dropdowns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Populate Cell based in information in pervious cell

Automatically populate columns in Excel based on another column information

Populate a cell based on another tab's information with a function

[SOLVED] populate row information based on cell condition or cell value

Populate cells with specific information based on one cell

Populate data based on cell information

Populate a cell with information that is based on 2 items in the spreadsheet.

Bookmarks

Bookmarks

Posting Permissions