Match Code

  • Thread starter Todd Huttenstine
  • Start date

T

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
 
Ad

Advertisements

T

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)
 

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

Top