Hi guys, I am really struggling with a piece of code.

Basically, I need to select a name from ComboBox3, a week number from Combobox1 and then textbox3 populate from it with a value found on sheet stats

Column A:A has the Week number in it, Column C:C has the name in it and I need it to return the value from column D:D

I'm trying to use the index/match function in VBA, but its not working; is there something wrong with my syntax or something? It returns the right value, but when I change the week number it doesnt update...I'm a bit lost to be honest!

Textbox3.Value = Test5


Test5 = Application.WorksheetFunction.Index(Sheets("Stats").Range("A:X"), Application.WorksheetFunction.Match(Qr, Sheets("Stats").Range("C:C"), 0), 4)