vba index match syntax

[Ganesh Kumar Subramanian]

Hello everybody,

I want to know the vba code syntax for the below formula,

Excel formula:
=INDEX(A:H,MATCH(1,("Dan Brown"=F:F)*(B2=G:G),0),8)

Vba Code:
???

Please help to me to write vba code for above formula. I am new to vba.

Thanks.

 

[CalcSux78]

Here's a vba function I wrote for another project:

Function IndexMatch(LookFor As Range, SearchRng As Range, ReturnRng As Range) As Variant
Application.Volatile
IndexMatch = WorksheetFunction.Index(ReturnRng, _
    WorksheetFunction.Match(LookFor, SearchRng, 0), 0)
End Function