Match Code

  • Thread starter Todd Huttenstine
  • Start date


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


range("W1").value = Application.Index(Range("X4:X29"), _

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question