Excel Match Value of a Cell and Return Value of Another Cell

Posted on 2013-11-12
Last Modified: 2013-11-13
I have an ActiveX ComboBox that populates options from another sheet using ListFillRange (Sheet3!A:A).  That ComboBox also has a LinkedCell (Sheet1!B3)

When an option is selected in Sheet1 ComboBox1, I need to return the value in Sheet3 column B for the matching selection.

For Example

CITY                      STATE
Kansas City            MO
Denver                   CO
Omaha                   NE
Dallas                     TX

Kansas City

When "Kansas City" is selected in ComboBox1, I need Sheet2!B1 to display "MO".
Question by:jackadmin
  • 2
LVL 23

Expert Comment

ID: 39641807
Is the activeX returning a number to a cell showing the relative choice made?

If so,


where A2 shows the result of the combobox choice made
LVL 49

Accepted Solution

Rgonzo1971 earned 250 total points
ID: 39641818

pls try


Open in new window

LVL 35

Expert Comment

by:[ fanpages ]
ID: 39641831

Alternatively, change the following Properties of the ActiveX ComboBox control:

Column Count: 2
Bound Column: 2
Column Widths: 10pt; 0 pt  [<- any width first that will cover the width of the control, but 0 pt for the second]
ListFillRange: Sheet3!A:B

When you select a CITY entry now, the corresponding value of STATE will be returned to the LinkedCell [B3].

Change the LinkedCell property to B1 to return to that cell instead.


LVL 35

Expert Comment

by:[ fanpages ]
ID: 39643920
You're welcome.


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

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

863 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

25 Experts available now in Live!

Get 1:1 Help Now