Been pounding my head on this one. I have the following function which works fine in excel however the VBA result isn't working for me.



{=INDEX($L$6:$R$19,(MATCH(B7&C7,$M$6:$M$19&$L$6:$L $19,0)),3)}

my vba code looks like:

Function FTest(tk as string, tk2 as string, Col as integer)

test = Application.WorksheetFunction.Index (Sheets("Index_Match").Range("M6:M19"), _
Application.WorksheetFunction.Match(Tk, Sheets("Index_Match") .Range("L6:R13"), 0), Col)

Set FTest = test.Value
End Function

My result is coming back as 0.0 which isn't making much sense since my range of data has all text at the moment.

any ideas?

Hi,

Perhaps this may help. I found it on line.

test = Application.WorksheetFunction.Index(Sheets("Worker s List").Range("C3:C13"), Application.WorksheetFunction.Match(1, Sheets("Workers List").Range("D313"), 0), 1)