Spreadsheet: 215779d1361478298-conditional-lookup-for-duplicate-values-book1
Sheet: Sheet1

poNbr | Exception type | result
[PHONE] | 2
[PHONE] | 1
[PHONE] | 5
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 1
[PHONE] | 1
[PHONE] | 8
[PHONE] | 8
[PHONE] | 7
[PHONE] | 7
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 11
[PHONE] | 2
[PHONE] | 11
[PHONE] | 2
[PHONE] | 8
[PHONE] | 8
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 6
[PHONE] | 6
[PHONE] | 6
[PHONE] | 6
[PHONE] | 6
[PHONE] | 6
[PHONE] | 1
[PHONE] | 6
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 1
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 11
[PHONE] | 2
[PHONE] | 11
[PHONE] | 2
[PHONE] | 11
[PHONE] | 2
[PHONE] | 11
[PHONE] | 1
[PHONE] | 11
[PHONE] | 11
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 11
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 11
[PHONE] | 1
[PHONE] | 11
[PHONE] | 2
[PHONE] | 2
[PHONE] | 11
[PHONE] | 11
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 3
[PHONE] | 7
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 11
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 10
[PHONE] | 3
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 1
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 3
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 11
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 3
[PHONE] | 2
[PHONE] | 2
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 11
[PHONE] | 7
[PHONE] | 8
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 8
[PHONE] | 1
[PHONE] | 1
[PHONE] | 7
[PHONE] | 7
[PHONE] | 1
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 7
[PHONE] | 1
[PHONE] | 7
[PHONE] | 1
[PHONE] | 3
[PHONE] | 8
[PHONE] | 2
[PHONE] | 8
[PHONE] | 2
[PHONE] | 8
[PHONE] | 8
[PHONE] | 8
[PHONE] | 8
[PHONE] | 8
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 8
[PHONE] | 2
[PHONE] | 1
[PHONE] | 5
[PHONE] | 2
[PHONE] | 7
[PHONE] | 1
[PHONE] | 1
[PHONE] | 6
[PHONE] | 2
[PHONE] | 6
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 8
[PHONE] | 7
[PHONE] | 1
[PHONE] | 1
[PHONE] | 11
[PHONE] | 2
[PHONE] | 7
[PHONE] | 1
[PHONE] | 7
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 11
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 3
[PHONE] | 11
[PHONE] | 11
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 11
[PHONE] | 11
[PHONE] | 11
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 4
[PHONE] | 3
[PHONE] | 2
[PHONE] | 1
[PHONE] | 11
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 1
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 2
[PHONE] | 3
[PHONE] | 3
[PHONE] | 2
[PHONE] | 2
[PHONE] | 1
[PHONE] | 2
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 2
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 11
[PHONE] | 6
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 1
[PHONE] | 3
[PHONE] | 3
[PHONE] | 3
[PHONE] | 1
[PHONE] | 3
[PHONE] | 10
[PHONE] | 3
[PHONE] | 4
[PHONE] | 3
[PHONE] | 8
[PHONE] | 2
[PHONE] | 1
[PHONE] | 8
[PHONE] | 1
[PHONE] | 8
[PHONE] | 1
[PHONE] | 8
[PHONE] | 2
[PHONE] | 8
[PHONE] | 2
[PHONE] | 8
[PHONE] | 8
[PHONE] | 8
[PHONE] | 8
[PHONE] | 8
[PHONE] | 2
[PHONE] | 3