Help with a UDF Function using Arrays...

D

Dennis G.

Hello,

I am trying to write my first UDF... Basically, it takes the form of this
Formula:
{index($a$1:$g$100,match(c2,$b$1:$b$100,0),30)}

The arrays are normally on a different sheet within the workbook.

The function I created is as follows:
Function McreProfile(a As Range, b As Range, c As Range, d As Integer)
'This will return the Medicare Profile on the excel sheet...
McreProfile = Application.Evaluate("=Index(" & a.Address & ",match(" &
b.Address & "," & c.Address & ",0)," & d & ")")
End Function

On the worksheet I entered and I get a #N/A
=McreProfile('pprrvu03 MIA'!$A$1:$AJ$13391,Dade!I2,'pprrvu03
MIA'!$A$1:$A$13391,32)

Your help is greatly appreciated...
Thanks - Dennis G.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top