Spreadsheet: 859651d1707969841-comparing-values-betwen-sheets-and-returning-values-book1
Sheet: EUC

CI NAME | Exists? In DV range | Match | Address of Match | Row of Match | Colum of match | Name (row) associated with match | Name (column) associated with match |  | match | MATCH(A2,DV!$B$2:$F$11)
JM3532 |  | ? | $D$6 | 6 | 4 | Test 1 | Asset 2 |  | Address of Match | ADDRESS(MATCH(A2,DV!$B$2:$F$11),COLUMN(DV!$A2))
DP2960 | Not |  |  |  |  |  |  |  | Row of Match | MATCH(A2,DV!$B$2:$F$11)
DP2961 | Not |  |  |  |  |  |  |  | Column of Match | MATCH(A2, DV!$B$2:$F$11, 0)
DP7356 | Not |  |  |  |  |  |  |  | Name Associated with Match | INDEX(DV!$A:$A,E2)
DP9882 | Not
DQ0683 | Not
DQ0775 | Not
DQ2256 | Not
DQ2403 | Not
DQ3656 | Not
DR0386 | Not
DR0494 | Not
DR2454 | Not
DR3060 | Exists | ? | $F$8 | 8 | 6 | My Tester | Asset 4
DR4134 | Exists | ? | $F$10 | 10 | 6 | Another Name | Asset 4
DR6177 | Exists | ? | $E$8 | 8 | 5 | My Tester | Asset 3
DR6604 | Not
DR8546 | Not
DR8555 | Not
DR9155 | Not
DR9660 | Exists | ? | $E$10 | 10 | 5 | Another Name | Asset 3
DR9908 | Not
DZ0979 | Not
JD0062 | Not
JD0342 | Not
JD1750 | Not
JL0709 | Not
JL1896 | Not
JL3021 | Not
JL4050 | Not
JL4352 | Not
JL4691 | Not
JL5091 | Not
JL5120 | Not
JL5337 | Not
[NAME] | Not
JL6869 | Not
JL7066 | Not
JL7904 | Exists | ? | $[NAME] | 11 | 4 | Smith, [NAME] | Asset 2
JL7939 | Not
JL8019 | Not
JL8020 | Not
JL8030 | Not
JL8031 | Not
JL8043 | Not
JL8044 | Not
JL8573 | Not
JL8628 | Not
JL9418 | Exists | ? | $D$12 | 12 | 4 | Jones, [NAME] | Asset 2
JL9438 | Exists | ? | $D$14 | 14 | 4 | [NAME] | Asset 2
JL9493 | Not
JL9563 | Not
JL9564 | Not
JL9589 | Not
JL9596 | Not
JM0016 | Not
JM0135 | Not
JM0138 | Not
JM0144 | Not
JM0189 | Not
JM0212 | Not
JM0215 | Not
JM0401 | Not
JM0731 | Not
JM0888 | Not
JM0941 | Not
JM1136 | Not
JM1296 | Not
JM1462 | Not
JM1560 | Not
JM1587 | Not
JM1589 | Not
[NAME] | Not
JM1863 | Not
JM1866 | Not
JM1868 | Not
JM1871 | Not
JM1874 | Not
JM2139 | Exists | ? | $[NAME] | 7 | 4 | Test 2 | Asset 2
[NAME] | Not
JM2148 | Not
JM2210 | Not
JM2252 | Not
JM3532 | Exists | ? | $D$6 | 6 | 4 | Test 1 | Asset 2
JM3577 | Not
JM3641 | Exists | ? | $D$15 | 15 | 4 | [NAME] who | Asset 2
JQ1439 | Not
JQ1499 | Not
JQ1812 | Not
JQ2217 | Not
JQ2278 | Not
JQ3767 | Not
JQ3768 | Not
JQ3770 | Not
JQ3774 | Not
JQ3777 | Not
JQ4085 | Not
[NAME] | Not
JQ4852 | Exists | ? | $F$11 | 11 | 6 | Smith, [NAME] | Asset 4
JQ4856 | Exists | ? | $E$11 | 11 | 5 | Smith, [NAME] | Asset 3
JQ4913 | Not
JQ4914 | Not
JQ5119 | Exists | ? | $E$7 | 7 | 5 | Test 2 | Asset 3
JQ7633 | Exists | ? | $F$9 | 9 | 6 | Somebody Namse | Asset 4
JQ7636 | Exists | ? | $E$9 | 9 | 5 | Somebody Namse | Asset 3
JQ8387 | Not
JQ8388 | Not
JQ8749 | Not
JQ8907 | Not
JQ8908 | Not
JQ9415 | Not
JQ9546 | Not
JQ9786 | Not
JQ9787 | Not
JQ9788 | Not
JQ9789 | Not
JR0410 | Not
[NAME] | Exists | ? | $F$7 | 7 | 6 | Test 2 | Asset 4
JR0453 | Not
JR1380 | Not
JR1643 | Not
JR1746 | Not
JR2057 | Not
JR2061 | Not
JR2078 | Not
JR2092 | Not
JR2095 | Not
[NAME] | Exists | ? | $F$12 | 12 | 6 | Jones, [NAME] | Asset 4
JR2814 | Exists | ? | $F$15 | 15 | 6 | [NAME] who | Asset 4
JR2844 | Exists | ? | $E$12 | 12 | 5 | Jones, [NAME] | Asset 3
JR2872 | Exists | ? | $E$15 | 15 | 5 | [NAME] who | Asset 3
JR2875 | Exists | ? | $F$14 | 14 | 6 | [NAME] | Asset 4
[NAME] | Not
JR2982 | Not
JR3034 | Not
JR3035 | Not
JR3131 | Exists | ? | $F$13 | 13 | 6 | Ash, Burn | Asset 4
JR3181 | Not
JR3668 | Not
JR3791 | Not
JR3966 | Not
JR4496 | Not
JR5550 | Not
[NAME] | Not
JR5846 | Not
JR6436 | Not
JR6989 | Not
JR7011 | Not
JR7016 | Not
JR7018 | Not
JR7019 | Not
JR7028 | Not
JR7137 | Not
[NAME] | Not
JR7139 | Not
JR7140 | Not
JR7275 | Not
JR7401 | Not
JR7915 | Not
JR7949 | Exists | ? | $E$13 | 13 | 5 | Ash, Burn | Asset 3
JR8001 | Not
JR8007 | Not
JR8317 | Exists | ? | $E$14 | 14 | 5 | [NAME] | Asset 3
JR8377 | Not
JR8389 | Not
JS0100 | Not
JS0111 | Not
JS0118 | Not
JS0119 | Not
JS0177 | Not
JS0284 | Not
JS0495 | Not
JS0496 | Not
JS0633 | Not
JS0635 | Not
JS0637 | Not
JS0639 | Not
JS0691 | Not
JS0692 | Not
JS0694 | Not
JS0695 | Not
JS0827 | Not
JS0828 | Not
JS0871 | Exists | ? | $F$6 | 6 | 6 | Test 1 | Asset 4
JS0872 | Exists | ? | $E$6 | 6 | 5 | Test 1 | Asset 3
JS1267 | Not
JS1268 | Not
JS1458 | Not
JS1459 | Not
JS2829 | Not
JS2830 | Not
JS2868 | Not
JS2871 | Not
[NAME] | Not
JS2876 | Not
TP0839 | Not
TP2301 | Not
TP3971 | Not
TP3972 | Not