Excel Match Value of a Cell and Return Value of Another Cell
Posted on 2013-11-12
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.
Kansas City MO
When "Kansas City" is selected in ComboBox1, I need Sheet2!B1 to display "MO".