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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 51

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

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…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

734 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