Matching row of SOURCE table against TARGET table (array)

**tmwcarl** · 03-06-2012, 03:57 PM

Hi all, I have two tables combined onto one sheet for simplicity; one is Source and the other is Target. I'm trying to see if each row from the Source table is found in the Target table. If possible, flag the rows of each table upon a match.

(e.g. the first match will have a corresponding "1" by each row on each table that matches, the next match will have a corresponding "2" or some other way to identify the line of each table that matches.)

NOTE: the actual files are two different spreadsheets.

Any help would be greatly appreciated!

**tigeravatar** · 03-06-2012, 04:10 PM

tmwcarl,

Attached is a modified version of your example workbook. I inserted a row (column I) for the matching numbers for the TARGET table.

In cell D6 and copied down is this formula for the SOURCE table:

Please Login or Register  to view this content.

In cell I6 and copied down is this formula for the TARGET table:

Please Login or Register  to view this content.

Note that I used excel an 2003 and lower compatible formula because you uploaded a .xls file, even though you have excel 2007 listed as your excel version. You could use a countifs formula instead of the sumproduct, but that is only excel 2007 and higher.

Is something like that what you were looking for?

**dilipandey** · 03-06-2012, 04:17 PM

Hi tmwcarl,

Welcome to the forum.
See the attached file and let me know if this is what you were loooking for. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**tmwcarl** · 03-06-2012, 05:12 PM

Thanks tigeravatar, yes i have an older version and this works great. Thanks a bunch.

Thanks dilipandey, this works great also. I appreciate it!

I'm so glad i found this forum, there are a lot of helpful people here. I glad to be aboard. Searching through this site, i have learned a lot about Excel and i have a lot more to learn. . .