I am trying use index/match to take the value of a combobox, and use it as the field to lookup and diplay a related field in a textbox.

Combobox: "BodySelect", is populated by single column aptly list named "BodyList"

Next to "BodyList", is the single column "BodyDesignator"

I want to the corresponding "BodyDesignator" to output into my textbox, "PartNumber".

My lists are all named globally and I call them in several other functions in my workbook.

I cannot for the life of me get the code formatted properly. I have tried vlookup, but kept getting either error 2015 or error 2042. The closet I got was 4 out of 5 options workign correctly, but the fifth always returned Error 2042 even though the result was definitely in the table and formatted exactly the same way as the rest of the results, so I thought I would try indexmatch but now cant even get that far.

The ComboBox and TextBox are located in spreadsheet "Interface", while the two lists are in the spreadsheet "Menus".