Solved

Drop down selection populates fields

Posted on 2016-09-27
3
42 Views
Last Modified: 2016-09-27
Hi all,

Let me describe my Excel workbook.

Sheet1 = a drop-down box to select a country.
Sheet2 = a list of countries with address and other details.
Sheet3 = A place to display the correctly formatted address and other details, selected by country on Sheet1.

Can someone guide me as to the magic I need to display the correct info on Sheet3?

Thanks
Andy
lookup_test.xlsx
0
Comment
Question by:Andrew Pratt
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
ID: 41817808
Refer to the attached and see if this is what you were trying to achieve...
lookup_test.xlsx
1
 

Author Comment

by:Andrew Pratt
ID: 41819182
Perfect Neeraj, exactly what I was after. Thank you.
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41819183
You're welcome Andrew! Glad to help.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now