Vlookup combo boxes and list boxes

[marissan1]

Hi
Forgive my ignorance if I titled this post incorrectly.

I created a wage spreadsheet and subsequently a pay stub.
The data is entered by week, ie. name, hourly rate, pay calculations, and totals.
I need to generate payslips by the week number for 10 employees but I am having trouble linking the combo box with the names and the list box with the week numbers.

Any suggestions on how I go about fixing this.
Thank
marissa

[royUK]

Why are you using ComboBoxes and what type are you using? Data validation lists would probably be a better option

[marissan1]

Greetings
I am using a Control Box (form control) which is pulling employee name for reference, and a list box with week numbers. I have managed to get the info relating to week 1 coming through, but the differentation of data for the same employee for week two to five is confusing me.