Hey guys

I have 2 comboboxes. Combobox2 and Combobox5. Combobox2
is populated with values from range Y4:Y29. Cell W2
contains a value. This value will match one of the values
in range Y4:Y29. I need for a code to find this matching
value in this range and offset 1 to the left and put that
value in cell W1.

What is the code for this?

Thank you
Todd Huttenstine