multiple criteria search

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!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I updated the code to this thinking I had made an error but its still not working, does anyone have any idea whats wrong with it?

Please Login or Register  to view this content.

I updated the code to this thinking I had made an error but its still not working, does anyone have any idea whats wrong with it?