Solved

WHat is this Excel Lookup. How do I create one?

Posted on 2013-06-08
2
272 Views
Last Modified: 2013-06-08
Hi,
I am fairly good with Excel but have stumbled upon a "lookup" type cell that I do not understand.

See attached sheet "Calculation"  and note the "lookup" around cell C9 - where it refers to "Low Income","Middle Income" etc.

How do I create a lookup like this?


Thanks!
Global-External-Debt-Stocks-Dash.xlsx
0
Comment
Question by:Patrick O'Dea
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39231265
This is a listbox form control and you can find how to use it here

http://support.microsoft.com/kb/291073
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39231431
Thanks, got it now!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

911 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

17 Experts available now in Live!

Get 1:1 Help Now