LOOKUP, MATCH MORE MATCHES IN TWO COLUMN

[peranish]

I having datas in two sheets. I want result which matches more than
one results for one criteria

Example

Sheet-1 Sheet -2
Col-a Col-a Col-b
aa-01 aa-01 abc-01
bb-01 bb-01 acd-02
cc-01 aa-01 adc-03
aa-02 aa-02 abc-02
ab-02 cc-01 abc-03

I got formula from your link(IF(ISERROR(INDEX($A$1:$B$24,SMALL(IF($A
$1:$A$24=$D$26,ROW($A$1:$A$24)),ROW(1:1)),2)),"",INDEX($A$1:$B$24,SMALL
(IF($A$1:$A$24=$D$26,ROW($A$1:$A$24)),ROW(1:1)),2)) & it works &
result getting in next rows. But i want in next column.
Example result reqd in Sheet-1 as below
Col-a Col-b Col-c
Criteria Match-1 Match-2
aa-01 abc-01 adc-03
bb-01 acd-02
cc-01 abc-03
aa-02 abc-02
ab-02

Please help on this to save my time.
Awaiting your reponse please

Thanks
Peranish

 

[Patrick Molloy]

with teh criteria in column A
then for results in columnB

=IF(OR(ISERR(MATCH($A3,Sheet1!A:A,FALSE)),ISERROR(MATCH(Sheet3!A3,Sheet2!A:A,FALSE))),"",VLOOKUP(Sheet2!$A5,Sheet1!A:B,2,FALSE))

for results in column C
=IF(OR(ISERR(MATCH($A3,Sheet1!B:B,FALSE)),ISERROR(MATCH(Sheet3!A3,Sheet2!A:A,FALSE))),"",VLOOKUP(Sheet2!$A5,Sheet2!A:B,2,FALSE))