Solved

Drop down selection populates fields

Posted on 2016-09-27
3
57 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 29

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 29

Expert Comment

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

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

773 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