Hi
there are some missing parenthesis. Try
Res = WorksheetFunction.Index
(Range("LOOKUP81!$A$1:$B$3"),MATCH(Range("81!F"&
Z),Range("LOOKUP81!$A$1:$A$3"),0),2)

--
Regards
Frank Kabel
Frankfurt, Germany


Dthmtlgod wrote:
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