Spreadsheet: 173359d1344524779-how-to-ignore-blank-cells-while-using-lookup-function-e1
Sheet: Sheet2

Project Number | Material Number | Description | P/O Doc. # | [NAME] | [NAME]. | [NAME] | Order Date | Req'd Date | [NAME] | Delivery Date
C.A5305.120 | K.00003.192.16.00 |  | [PHONE] |  | bb/jb - 06/01/12 | 2 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.120 | K.00003.198.55.00 |  | [PHONE] |  | bb/jb - 06/01/12 | 1 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.120 | K.00003.192.16.00 |  | [PHONE] |  | bb 18.06.2012 | 1 | 2012-06-07 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.120 | K.00003.192.13.00 |  | [PHONE] |  | bb 30.05.2012 | 5 | 2012-05-25 00:00:00 | 2012-08-24 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.120 | C.05305.123.01.00 |  | [PHONE] |  | pv/db 07/12/12 | 2 | 2012-07-10 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-09-05 00:00:00
C.A5305.130 | K.00003.418.26.00 |  | [PHONE] |  | tb31.05.2012 | 1 | 2012-05-31 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-06-22 00:00:00
C.A5305.130 | C.05305.SRV.04.01 |  | [PHONE] |  |  | 1 | 2012-05-09 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-07-10 00:00:00
C.A5305.130 | C.05305.SRV.05.01 |  | [PHONE] |  |  | 1 | 2012-05-09 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-07-10 00:00:00
C.A5305.130 | C.05305.SRV.06.01 |  | [PHONE] |  |  | 1 | 2012-05-09 00:00:00 | 2012-08-10 00:00:00 | 0 | 2012-07-10 00:00:00
C.A5305.130 | K.00003.418.26.00 |  | [PHONE] |  |  | 8 | 2012-05-03 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-07-31 00:00:00
C.A5305.130 | K.00003.246.75.00 |  | [PHONE] |  | BB/ECK 8/01/12 | 1 | 2012-07-28 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-03 00:00:00
C.A5305.130 | K.00003.459.91.00 |  | [PHONE] |  |  | 17 | 2012-07-12 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-03 00:00:00
C.A5305.130 | K.00003.338.70.00 |  | [PHONE] |  | bb/jb - 05/18/12 | 2 | 2012-05-17 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00
C.A5305.130 | K.00003.418.26.00 |  | [PHONE] |  | bb/jb - 05/18/12 | 1 | 2012-05-17 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00
C.A5305.130 | C.05305.139.51.00 |  | [PHONE] |  | TC 19.04.2012 | 1 | 2012-04-18 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-17 00:00:00
C.A5305.130 | K.00003.166.16.00 |  | [PHONE] |  | bb 30.05.2012 | 7 | 2012-05-25 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.166.17.00 |  | [PHONE] |  | bb 30.05.2012 | 27 | 2012-05-25 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.192.16.00 |  | [PHONE] |  | bb/jb - 06/01/12 | 2 | 2012-05-25 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.186.25.00 |  | [PHONE] |  | bb 30.05.2012 | 12 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.198.54.00 |  | [PHONE] |  | bb/jb - 06/01/12 | 2 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.192.14.00 |  | [PHONE] |  | bb/jb - 06/01/12 | 4 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.246.81.00 |  | [PHONE] |  | bb/jb - 6/8/12 | 4 | 2012-06-06 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.166.21.00 |  | [PHONE] |  | bb 18.06.2012 | 2 | 2012-06-07 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.192.16.00 |  | [PHONE] |  | bb 18.06.2012 | 2 | 2012-06-07 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.166.17.00 |  | [PHONE] |  | bb 18.06.2012 | 2 | 2012-06-07 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | C.R0104.021.MM.00 |  | [PHONE] |  | bb 05.07.2012 | 1 | 2012-06-27 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.166.21.00 |  | [PHONE] |  | BB/ECK 7/19/12 | 2 | 2012-07-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.192.15.00 |  | [PHONE] |  | BB/ECK 7/19/12 | 1 | 2012-07-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.192.16.00 |  | [PHONE] |  | BB/ECK 7/19/12 | 1 | 2012-07-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00003.186.25.00 |  | [PHONE] |  | BB/ECK 7/19/12 | 2 | 2012-07-11 00:00:00 | 2012-08-03 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.130 | K.00635.571.ST.40 |  | [PHONE] |  |  | 3 | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-10-26 00:00:00
C.A5305.130 | C.05305.121.01.00 |  | 11214677 |  | N | 1 |  | 2012-08-02 00:00:00
C.A5305.130 | C.05305.325.01.00 |  | 11214952 |  | N | 1 |  | 2012-08-02 00:00:00
C.A5305.130 | C.05309.311.02.00 |  | 11214956 |  | N | 1 |  | 2012-08-02 00:00:00
C.A5305.130 | C.R0104.035.MM.00 |  | 11214792 |  | N | 1 |  | 2012-08-02 00:00:00
C.A5305.130 | K.00003.387.64.00 |  | 11214630 |  | N | 2 |  | 2012-08-02 00:00:00
C.A5305.130 | K.00638.827.02.00 |  | 11207980 |  | N | 1 |  | 2012-08-02 00:00:00
C.A5305.310 | K.00003.396.80.00 |  | [PHONE] |  | BB 20.06.2012 | 1 | 2012-06-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.310 | K.00003.396.80.00 |  | [PHONE] |  | bb/jb - 6/26/12 | 1 | 2012-06-15 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00
C.A5305.320 |  |  | [PHONE] |  | pv/db 07/05/12 | 2 | 2012-07-03 00:00:00 | 2012-07-19 00:00:00 | 0 | 2012-08-03 00:00:00