| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match Code
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Match Code
=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 ) -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding a single word match in a text string and assigning a code | Excel Worksheet Functions | |||
| Create Bar code Sheet w/lookups, index/match | Excel Worksheet Functions | |||
| Paste in "match destination format" macro code | Excel Discussion (Misc queries) | |||
| Calling Match function from code | Excel Programming | |||
| Match Function(Code modification) | Excel Programming | |||
Hybrid Mode
