Urgent!!! Translate index/match function to vba code

    Hi I need some help here.


    How do I translate this to a VBA code?


    =IFERROR(INDEX('DN transaction log'!C:K,MATCH(1,('Array (2)'!D2='DN transaction log'!C:C)*("Cargo Received"='DN transaction log'!F:F),0),7),"")


    Thanks a lot!!

    Re: Urgent!!! Translate index/match function to vba code


    Are you looking to have VBA put that exact formula into a cell or are you looking for VBA to give you the same result as that formula?

    Bruce :cool:

    Re: Urgent!!! Translate index/match function to vba code


    Which cell is it going in? What Range? Is this Range Variable i.e. number of rows that change? Which column? Which Sheet?

    Re: Urgent!!! Translate index/match function to vba code


    Sample Code


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login