application.vlookup

thanks.
though i'm still not entirely sure where I'm putting this in my code, or how to reference a different workbook.

Does it make it easier if I then link the Pertrac Report to a hidden sheet in the workbook that holds my user form, effectively moving the table into the workbook (but so that it gets updated when the other workbook does.
So now I want to look up the Fund name chosen in cmbFnd from the sheet PertracReport in the same workbook and enter the relevant ISIN into txtISIN.
Is that possible?
TIA

You can read the table in

S:\IAM Institutions\Institutional Master\Client - Product Matrix IB.xlsm on the worksheet 'PerTrac Report', Range A6:B71 in one move into your combobox

Private Userform_Initialize()
   with workbooks.add "S:\IAM Institutions\Institutional Master\Client - Product Matrix IB.xlsm "
      cmbFunds.list=.sheets("'PerTrac Report").range("A6:B71").value
     .close false
   end with
End sub

If you choose the fund's name in the combobox you can see the ISIN-code in textbox1 using

Private sub cmbFunds_Change()
   if cmbFunds.listindex>-1 then teTxBox1.Text=cmbfunds.List(cmbFunds.Listindex,2)
End Sub

It looks promising but I'm getting
Run-time error '9':
Subscript out of range.

Any suggestions?
Thanks

Ok I had a fiddle, but I'm still getting issues.
currently it's;

   Private Sub UserForm_Initialize()
    With Workbooks.Add("S:\IAM Institutions\Institutional Master\Client - Product Matrix IB.xlsm")
         cmbFnd.List = .Sheets("PerTrac Report").Range("A6:B71").Value
     .Close False
   End With
End Sub

and then

Private Sub cmbFnd_Change()
 If cmbFnd.ListIndex > -1 Then
 txtISIN.Value = cmbFnd.List(cmbFnd.ListIndex, 2)
 End If
End Sub

and it comes up with
Run-time error '-2147024809 (80070057)';
Could not get the list property. Invalid argument.
I'm pretty certain it's something to do with the second bit because that happens after I've chosen from the combobox but I have no idea what's going on.
thanks