I am trying to return a value (RES) using INDEX/MATCH in VBA.

Res = WorksheetFunction.Index (Range("LOOKUP81!$A$1:$B$3",MATCH(Range("81!F"
& Z),Range("LOOKUP81!$A$1:$A$3),0,2)))

I trying to find a match and return a value. The statement continues to
error out. It works fine as a formula through the application =INDEX
(LOOKUP81!$A$1:$B$3,MATCH($F5,LOOKUP81!$A$1:$A$3,0 ),2)

Please assist.

Thanks