broj_1=0001
broj_2=02

With Application.WorksheetFunction
 rezultat = .Index(Range(Cells(1, 1), Cells(6, 3)), _
                .Match(broj_1, Range(Cells(1, 1), Cells(6, 1)), 0) + _
                .Match(broj_2, Range(Cells(1, 2), Cells(6, 2)), 0) - 1)
End With