• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

callup INDEX/MATCH function in VBA

N

nbeharry

New Member
Hi everyone, hope all is well. I need some help once again so I'm reaching out to my favorite site that always come true for me.

I need to write this formula in VBA but for some reason, I just cannot get it. Can someone help, pretty Please.

=INDEX(BankAC,MATCH(Garage!A9,BankInfo!$A$5:$A$3000))


my file has two sheets: sheet1 is named Garage, and sheet2 is named Bankinfo. BankAC is my named range to index. Thanks.
 
What do you want done with the formula? If we're just putting it in a cell, should be able to just do something like this:
Code: 
ActiveCell.Formula = "=INDEX(BankAC,MATCH(Garage!A9,BankInfo!$A$5:$A$3000))"
 
You must log in or register to reply here.
Back
Top