Solved

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

Posted on 2013-06-08
2
257 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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…
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…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

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

15 Experts available now in Live!

Get 1:1 Help Now