INDEX/MATCH error in VBA

[x65140]

VBA - Trying to match the value of cboPlayer1A (SHEET1) to another sheet (SHEET2) and bring back the txtPOS1a value.
SHEET2 is NOT sorted!!
Been trying different combinations with no success.
My latest error is: Unable to get the MATCH property of the WorksheetFunction class

Code:

If cboPlayer1A.Value <> "" Then
   txtPOS1A.Text = Application.WorksheetFunction.Index("SHEET2!C8:F34", Application.WorksheetFunction.Match(cboPlayer1A, "SHEET2!C8:C34", 0))
End If

cboPlayer1A and txtPOS1A are boxes in a form.
SHEET2 contains Name, data, data, data in C:F
Want to match the name in Column C and return data from the other columns