Using a worksheet function within a user defined function

[Atom]

How does one use/call any of the common worksheet functions within a user defined function?

I started on this because I wanted to convert this worksheet formula (which does case sensitive lookups) to a UDF.
={INDEX(Rng,MATCH(TRUE,EXACT(somevalue,Rng),0),1)}

[TMS]

Please Login or Register  to view this content.

for example

[Atom]

Thanks for the help. As it turns out, I discovered that the case sensitive lookup I wanted can be accomplished with a simple array forumula.
As in {=B1:B3=A1:A10}

[TMS]

Thanks for the update.

For future reference, please don't edit the original/opening post. If you do, it changes the context of any answers in the thread and it can become pointless/confusing.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Atom]

I've done a lot of looking, but I still do not know how to convert the array formula in the OP to a public function, so I'm still looking for help.