Match Code

[Todd Huttenstine]

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

 

[Tom Ogilvy]

=Index(X4:X29,Match(W2,Y4:Y29,0),1)


range("W1").value = Application.Index(Range("X4:X29"), _
application.Match(Range("W2"),Range("Y4:Y29"),0),1)