If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA code to perform index and match based off of userform combo box values

Thread starter Zimmerman
Start date Jun 8, 2018
Tags

box cell combo sheet sheet1

Zimmerman

Well-known Member

Jun 8, 2018

I'm hoping someone could help me out with creating this code. I have a userform that has 2 combo boxes. When the user clicks the OK command button I would like to perform an index and match based on what the user picks from the combo boxes. The first combo box will need to look up the text in a sheet named "RL" in column C. Then I need to find and match the value from "Sheet1" cell "K6" from column "D" in sheet "RL" and "Sheet1" cell "N6" from row 5 in sheet "RL". And in Sheet1 cell O6 I would like that lookup value to be returned to this cell + the value of the 2nd combo box.

Hope this makes sense and someone could possibly help
Windows 7
Excel 2016

Thanks you