Function as VB

[kgdemers]

I am somewhat new to VB and having trouble converting this recorded macro to VB<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Thanks in advance.<o></o>
=INDEX( [file.xlsx]sheetname!$A:$C,(MATCH(A13, ([file.xlsx]sheetname!$A:$A,0)+2),3)<o></o>

 

[Myproblem]

it think that the best way to do this to create add-in, with your function

 

[kgdemers]

I have loaded other peoples add-inss, but have never written one; can you provide any guidance on how to do that?

 

[Myproblem]

i used this link to create add in, there you have how to use that add in to make your macro working
and another link to read about it with example is this link

 

[kgdemers]

Thanks for the info; I will give it a try.