Guessing, but maybe

[vba]

Dim MyRange1 As Range
Dim MyRange2 As Range
Dim cell As Range
Dim cellA As Range
Dim i As Long
Set MyRange1 = Sheets(1).Range("C1")
Set MyRange2 = Sheets(1).Range("L1")
For i = 1 To UsedRange.Rows.Count
For Each cell In MyRange1
For Each cellA In MyRange2
If cell.Value = TextBox1.Text And cell.Offset(0, 1).Value = TextBox2.Text _
And cell.Offset(0, 2).Value = TextBox3.Text And cell.Offset(0, 3).Value = TextBox4.Text Then
cells(i, 12).Value = cell.Offset(i, -2).Value
cells(i, 13).Value = cell.Offset(i, -1).Value
cells(i, 14).Value = cell.Offset(i, 7).Value
cells(i, 15).Value = cell.Offset(i, 8).Value
cells(i, 16).Value = cell.Offset(i, 9).Value
cells(i, 17).Value = cell.Offset(i, 10).Value
End If

Next cellA
Next cell
Next i
[/vba]