I'm having trouble with using index/match with 2 criteria in VBA.
On the workbook it's simply:
{=MATCH(criteria1&criteria2,A2:A1001&B2:B1001,0)
In VBA I have (to be done with a sheet called 'Market Data')
tomatch = Application.WorksheetFunction.Match(criteria1 & criteria2, Sheets("Market...