Match Fomula

Occasional Visitor

I currently have two different spreadsheets that I want to compare and match data.  I have done so with successfully with this formula {=match(B2,Completed!C:C,0).  However, since the lookup array contains several occurrences of the lookup value, the position of the first value is returned and it stops trying to match additional rows.  Is there a way to get it to keep searching and provide a list (or something) of all the applicable rows?  I have provided an example of my workbook.  Thanks  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies