I NEED HELP for translate index/match function into vba code

[Vanessa16]

Hi, anyone please me save

how do i translate this to a vba code
=INDEX('16090540'!D2:D296,MATCH(MAX('16090540'!N2:N296),'16090540'!N2:N296,0))

what i have done is
test = Application.WorksheetFunction.Index(Sheets("16090540").Range("D2:D296"),Application.WorksheetFunction.Match(Application.WorksheetFunction.Max(Sheets("16090540").Range("N2:N296"),Sheets("16090540").Range("N2:N296"),0))

But I keep getting an error, may i know whats wrong with it?

 

[James006]

Hi,

The quickest solution for you ... is to turn you your macro recorder ...

and type in your formula ... :wink:

Hope this will help

 

[Fluff]

Hi & welcome to MrExcel.
You are missing a ) from the Max function.