Maybe you need to update your attachment
The is no data in Col D in Master Template, and there is no helper column built from other columns (using formulas)
Col A on Input is used to look for a equal in Col A on template
Are you saying that you want to match NAME+COUNTRY and get CAPTAIN?????????????????
Option Explicit
Function VLookup2(Input1 As Variant, Input2 As Variant, DataLookup As Range, DataReturn As Range) As Variant
Dim i As Long, rowLast As Long
Dim i1 As Variant, i2 As Variant
VLookup2 = CVErr(xlErrNA)
On Error GoTo NiceExit
With DataReturn
rowLast = .Parent.Cells(.Rows.Count, .Column).End(xlUp).Row
End With
i1 = LCase(Input1)
i2 = LCase(Input2)
For i = 1 To rowLast
If i1 = LCase(DataLookup.Cells(i, 1).Value) And i2 = LCase(DataLookup.Cells(i, 2).Value) Then
VLookup2 = DataReturn.Cells(i, 1).Value
Exit Function
End If
Next i
Exit Function
NiceExit:
End Function