Pete,
I have tried the match row formula, and I'm getting no return data. I'm not
getting any error message, so I know the array formula is correctly entered.
The rows i'm trying to match definitely have matches, so I'm not sure what is
wrong.

On the original example from Orlando, there wasn't any data in Column E, I'm
not sure why the formula references it, but followed as a blank column.

Any help would be greatly appreciated!

Array Formula (entered in Column G):
{=IF(ISNA(MATCH(F$4&"_"&ROW(F4),H:H)),"",INDEX(C:C ,MATCH(F$4&"_"&ROW(F4),H:H,0)))}



MATCH B RETURN MULTIPLES C LOOKUP DATA F
COL A COL B COL C COL D COL E COL F
JOBNO ACCOUNTNO TECH blank CMPLDATE ACCOUNTNO
103340 8383600080022459 4021 2/23/2010 8383600230075738
103912 8383600270464099 4179 8383600270083444
104372 8383600270462044 4066 8383600270106310
104989 8383600150028501 4062 8383600270462085
105181 8383600230075738 4080 8383600270464099
105357 8383600280656866 4181 8383600400133820
105560 8383600270460592 4033 8383601090023123
105658 8383600270083444 4248 8383600410118803
106070 8383600280633113 4196 8383600130036087
106335 8383600280621159 4143 8383600070024275
106675 8383600420002492 4187 8383600280499291
108070 8383600230075738 4171
109721 8383600410101080 4248
110796 8383600230066257 4063
111383 8383600270083444 4038
111698 8383600310130601 4089
111813 8383600280663763 4027
112417 8383600270464099 4143

Thanks,
Lynn








"Pete_UK" wrote:

You can set up another column to give you a unique reference. For
example, put this formula in E1:

=IF(C1="","",C1&"_"&COUNTIF(C$1:C1,C1))

then copy this down to cover the values in column C.

Then, with 22 in A1, you can put this formula in B1:

=IF(ISNA(MATCH(A$1&"_"&ROW(A1),E:E,0)),"",INDEX(D: D,MATCH(A$1&"_"&ROW
(A1),E:E,0)))

Then copy this down as far as you think you might need it (i.e. to get
all the duplicates).

Hope this helps.

Pete

On Jan 2, 8:10 pm, ORLANDO VAZQUEZ
wrote:
Thank you for your support.

Can someone please help me with the following array? type of question.

What formula can I use to return a list of results when there is more than
one result?
If I use VLOOKup it returns only the first instance of the result.

For example: Looking up cell a1 value of 22 should result in the following
list:
Dog
Biscuit
Steak

A B C D

22 34 Apple
33 34 Fish
16 22 Dog
91 1 Orange
15 3 Tangerine
14 22 Biscuit
21 1 Tea
34 5 Salmon
17 22 Steak
7 Herring
8 Cod
1 Orange
1 Castle