Need to Match 3 cells in a row to 3 cells in a row on another tab

**Mhall689** · 06-22-2015, 03:03 PM

Hi there,

I'm trying to match the cells with the first name, lastname and contract # from one tab with the same data on another. If there is not a match I need it to be identified. I have tried a few different formulas but nothing is working.

Any help would be greatly appreciated.

Thanks!

**newdoverman** · 06-22-2015, 03:14 PM

This will work with the enclosed example workbook

Formula:

Please Login or Register  to view this content.

**Mhall689** · 06-22-2015, 03:41 PM

Thank you very much! it worked perfect!

**newdoverman** · 06-22-2015, 04:04 PM

Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Need to Match 3 cells in a row to 3 cells in a row on another tab

LinkBack

Thread Tools

Rate This Thread

Display

Need to Match 3 cells in a row to 3 cells in a row on another tab

Re: Need to Match 3 cells in a row to 3 cells in a row on another tab

Re: Need to Match 3 cells in a row to 3 cells in a row on another tab

Re: Need to Match 3 cells in a row to 3 cells in a row on another tab

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

Excel: match two cells in one sheet to two cells in another and return a third cells value

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

Bookmarks

Bookmarks

Posting Permissions