asked on

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

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

Sheet3
CITY STATE
Kansas City MO
Denver CO
Omaha NE
Dallas TX

ComboBox1
Kansas City
Denver
Omaha
Dallas

When "Kansas City" is selected in ComboBox1, I need Sheet2!B1 to display "MO".

NBVC

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

If so,

=INDEX(Sheet3!$B$2:$B$5,A2)

where A2 shows the result of the combobox choice made

ASKER CERTIFIED SOLUTION

Rgonzo1971

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

[ fanpages ]

Hi,

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.

BFN,

fp.

[ fanpages ]

You're welcome.

(Sigh)