# 4 Field/Criteria Match/Vlookup?

#### whodtthr

##### New Member
I am trying to do a compare between 2 table on separate tabs in excel. Both tables have well over 200 rows and 4 columns. I need to confirm which rows already exist in the other table. And the ones that don't. I need to have sent of to a vendor to have them added. An example of the data in the two tables is below. I am thinking I need a combination of Match/Index. Any and all help is appreciated. I think I basically would need to add a 5th column that would say if it found an exact match in the other table, and #NA if isnt in the the other table. And I would know to send those off. Thanks
 '0001 '0001 88 KOCCC '0001 '0001 U2 KOCCC '0001 '0001 U7 KOCCC '0001 '0002 U2 KOCCC

<tbody>
</tbody>

 '0001 '0002 U2 KOCCC '0001 '0001 U6 KOCCC '0001 '0001 88 KOCCC '0001 '0001 U3 KOCCC

<tbody>
</tbody>

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
try
=IF(ISERROR(INDEX(\$A\$1:\$A\$4,MATCH(A1&B1&C1&D1,Sheet2!\$A\$1:\$A\$4&Sheet2!\$B\$1:\$B\$4&Sheet2!\$C\$1:\$C\$4&Sheet2!\$D\$1:\$D\$4,0))),"no match", "match")

use
control + Shift + Enter
so that an array formula is entered

you get {} around the formula

Replies
1
Views
497
Replies
2
Views
408
Replies
3
Views
356
Replies
3
Views
868
Replies
0
Views
423

1,196,306
Messages
6,014,565
Members
441,828
Latest member
cofracr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back