This is an ongoing unresolved problem. Here is a
different angle.

I have a table in Sheet1 with cost center numeric codes in
column A:A and function code numeric values in row 1:1.

There is a specific cost center numeric code in cell A1 on
Sheet2.

I need a code that will search down column A:A and find
the cell with the value that matches Sheet2 Cell A1. Lets
say Cell A15 is the match.

I then need the code to look across row 15 and populate
Combobox1's drop down with the value in any of this row's
cells that does not equal "no" or is blank.