Creating Formula with nested IF

[nms2130]

I am having some trouble with the formula below. It works welll in the worksheet, but I am trying to make it into a UDF so that I will not need to remeber all of it everytime I use it. The formula grabs all values mathing a certain criteria.

C4 is the criteria to match
C5 is the cell containing the value
Column A houses the values that I am trying to "grab"
Column B houses the criteria that I am matching against

Please Login or Register  to view this content.

I am trying to make this a function that only requires 3 inputs, the criteria range(C4), the starting cell of the values range and the starting cell(A5) of the criteria to match against (B5).

I am getting stuck on the portion that reads :

Please Login or Register  to view this content.

and I am unable to figure out how to make this an array formula.

Any help would be tremendously appreciated!!!

[shg]

Can you post a workbook with an example?

[nms2130]

Please see the attached nms2130 Sample.xls

[shg]

This is a little ad-hoc, but try it:

Please Login or Register  to view this content.

For example, select C5:C16, in the formula bar paste

=nms2130(A5:B16, "bb")

... then press and hold the Ctrl and Shift keys, then press Enter.

[nms2130]

shg, it is not really the result I am looking for, but I appreciate your taking the time to assist. Is it possible to use some sort of userform instead to insert the function based on highlighting the ranges?