Hi all,

I want an Index / Match function to return a result from another workbook but no matter the way i try my variable "orderamount" still returns nothing:


'get order amount in jx2015

Workbooks("Journaux_2015.xls").Activate
Sheets("Feuil1").Activate
            
orderamount = Application.WorksheetFunction.Index(Workbooks("Journaux_2015.xls").Sheets("Feuil1").sourcerange, _
Application.WorksheetFunction.Match(papername, Workbooks("Journaux_2015.xls").Sheets("Feuil1").Columns(1), 0), _
Application.WorksheetFunction.Match(paperdate, Workbooks("Journaux_2015.xls").Sheets("Feuil1").Rows(r), 0))
I am using variables in the match functions, one is as string and the other is as date, could that be the problem?

Thanks in advance for your help.