Spreadsheet: 539004d1505921104-hello-i-am-stuck-and-i-need-help-with-if-and-vlookup-formulas-need-help-valley-pl-excel-help
Sheet: Valley Bank 

Details | Posting Date | Description | Amount |  |  | Valley
DEBIT | 2017-04-27 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.43
DEBIT | 2017-04-26 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.21
DEBIT | 2017-04-24 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.85
DEBIT | 2017-04-21 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.56
DEBIT | 2017-04-19 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.26
DEBIT | 2017-04-18 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.19
DEBIT | 2017-04-17 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.13
DEBIT | 2017-04-17 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.16
DEBIT | 2017-04-14 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.17
DEBIT | 2017-04-13 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.74
DEBIT | 2017-04-12 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.91
DEBIT | 2017-04-10 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.21
DEBIT | 2017-04-06 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.33
DEBIT | 2017-04-05 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.78
DEBIT | 2017-04-04 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.46
DEBIT | 2017-04-03 00:00:00 | AMERICAN EXPRESS AXP DISCNT [PHONE]      CCD ID: [PHONE] | -0.74
CREDIT | 2017-04-27 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 15
CREDIT | 2017-04-26 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 7.5
CREDIT | 2017-04-24 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 30.1
CREDIT | 2017-04-21 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 19.82
CREDIT | 2017-04-19 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 10.53
CREDIT | 2017-04-18 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 6.83
CREDIT | 2017-04-17 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 4.56
CREDIT | 2017-04-17 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 5.53
CREDIT | 2017-04-14 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 6.04
CREDIT | 2017-04-13 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 32.73
CREDIT | 2017-04-12 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 31.71
CREDIT | 2017-04-10 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 7.49
CREDIT | 2017-04-06 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 11.58
CREDIT | 2017-04-05 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 27.36
CREDIT | 2017-04-04 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 16.38
CREDIT | 2017-04-03 00:00:00 | AMERICAN EXPRESS SETTLEMENT [PHONE]      CCD ID: [PHONE] | 25.94
CREDIT | 2017-04-10 00:00:00 | CASH DEPOSIT CREDIT ADJUSTMENT | 11
DEBIT | 2017-04-03 00:00:00 | CERTIFIED SECURI APRIL MONI                 PPD ID: [PHONE] | -26.03
DSLIP | 2017-04-26 00:00:00 | DEPOSIT | 301.18
DSLIP | 2017-04-26 00:00:00 | DEPOSIT | 491.9
DSLIP | 2017-04-26 00:00:00 | DEPOSIT | 641.3
DSLIP | 2017-04-24 00:00:00 | DEPOSIT | 636.66
DSLIP | 2017-04-24 00:00:00 | DEPOSIT | 700.49
DSLIP | 2017-04-24 00:00:00 | DEPOSIT | 710.04
DSLIP | 2017-04-24 00:00:00 | DEPOSIT | 741.37
DSLIP | 2017-04-19 00:00:00 | DEPOSIT | 555.32
DSLIP | 2017-04-17 00:00:00 | DEPOSIT | 254.43
DSLIP | 2017-04-17 00:00:00 | DEPOSIT | 542.02
DSLIP | 2017-04-17 00:00:00 | DEPOSIT | 843.55
DSLIP | 2017-04-14 00:00:00 | DEPOSIT | 609.93
DSLIP | 2017-04-13 00:00:00 | DEPOSIT | 543.47
DSLIP | 2017-04-12 00:00:00 | DEPOSIT | 606.59
DSLIP | 2017-04-11 00:00:00 | DEPOSIT | 590.74
DSLIP | 2017-04-10 00:00:00 | DEPOSIT | 399.83
DSLIP | 2017-04-10 00:00:00 | DEPOSIT | 681.48
DSLIP | 2017-04-10 00:00:00 | DEPOSIT | 693.88
DSLIP | 2017-04-07 00:00:00 | DEPOSIT | 620.44
DSLIP | 2017-04-07 00:00:00 | DEPOSIT | 685.96
DSLIP | 2017-04-05 00:00:00 | DEPOSIT | 567.44
DSLIP | 2017-04-05 00:00:00 | DEPOSIT | 621.67
DSLIP | 2017-04-03 00:00:00 | DEPOSIT | 445.2
DSLIP | 2017-04-03 00:00:00 | DEPOSIT | 605.85
DSLIP | 2017-04-03 00:00:00 | DEPOSIT | 625.87
DSLIP | 2017-04-03 00:00:00 | DEPOSIT | 642.01
DSLIP | 2017-04-03 00:00:00 | DEPOSIT | 686.85
DEBIT | 2017-04-26 00:00:00 | FOOD SERV OF AME ACCTS REC          1106981 CCD ID: [PHONE] | -1616.95
DEBIT | 2017-04-19 00:00:00 | FOOD SERV OF AME ACCTS REC          1106981 CCD ID: [PHONE] | -2486.63
DEBIT | 2017-04-12 00:00:00 | FOOD SERV OF AME ACCTS REC          1106981 CCD ID: [PHONE] | -2469.5
DEBIT | 2017-04-05 00:00:00 | FOOD SERV OF AME ACCTS REC          1106981 CCD ID: [PHONE] | -2280.3
DEBIT | 2017-04-05 00:00:00 | IC FEE SCWD#3    WEB PAYMNT 8302366         CCD ID: [PHONE] | -0.95
DEBIT | 2017-04-25 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -4452
DEBIT | 2017-04-07 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -4.45
DEBIT | 2017-04-04 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -381.52
DEBIT | 2017-04-28 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -782.88
DEBIT | 2017-04-21 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -713.34
DEBIT | 2017-04-17 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -516.62
DEBIT | 2017-04-14 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -785.59
DEBIT | 2017-04-07 00:00:00 | KAHALA CORP      XXXXXXXXXX                 PPD ID: [PHONE] | -806.22
DEBIT | 2017-04-03 00:00:00 | MERCHANT BNKCD   CHARGEBACK [PHONE]    CCD ID: [PHONE] | -2.15
CREDIT | 2017-04-28 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 881.87
CREDIT | 2017-04-27 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 760.76
CREDIT | 2017-04-26 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 564.76
CREDIT | 2017-04-26 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 573.42
CREDIT | 2017-04-26 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 879.95
CREDIT | 2017-04-25 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 760.47
CREDIT | 2017-04-24 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 698.43
CREDIT | 2017-04-21 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 966.52
CREDIT | 2017-04-20 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 774.3
CREDIT | 2017-04-19 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 363.32
CREDIT | 2017-04-19 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 688.41
CREDIT | 2017-04-19 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 875.25
CREDIT | 2017-04-18 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 965.14
CREDIT | 2017-04-17 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 681.61
CREDIT | 2017-04-14 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 785.61
CREDIT | 2017-04-13 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 609.26
CREDIT | 2017-04-12 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 582.71
CREDIT | 2017-04-12 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 591.99
CREDIT | 2017-04-12 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 836.74
CREDIT | 2017-04-11 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 923.95
CREDIT | 2017-04-10 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 727.85
CREDIT | 2017-04-07 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 653.61
CREDIT | 2017-04-06 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 694.88
CREDIT | 2017-04-05 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 565.6
CREDIT | 2017-04-05 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 598.59
CREDIT | 2017-04-05 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 1202.59
CREDIT | 2017-04-04 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 697.52
CREDIT | 2017-04-03 00:00:00 | MERCHANT BNKCD   DEPOSIT    [PHONE]    CCD ID: [PHONE] | 815.44
DEBIT | 2017-04-05 00:00:00 | MERCHANT BNKCD   DISCOUNT   [PHONE]    CCD ID: [PHONE] | -107.15
DEBIT | 2017-04-04 00:00:00 | MERCHANT BNKCD   DISCOUNT   [PHONE]    CCD ID: [PHONE] | -0.45
DEBIT | 2017-04-05 00:00:00 | MERCHANT BNKCD   FEE        [PHONE]    CCD ID: [PHONE] | -44.91
DEBIT | 2017-04-05 00:00:00 | MERCHANT BNKCD   INTERCHNG  [PHONE]    CCD ID: [PHONE] | -530.4
DEBIT | 2017-04-05 00:00:00 | Online Payment [PHONE] To CHASE CARDMEMBER SERVICES 04/05 | -100
DEBIT | 2017-04-10 00:00:00 | Online Payment [PHONE] To CAPITAL ONE 04/10 | -1147.28
DEBIT | 2017-04-17 00:00:00 | Online Payment [PHONE] To JC LAWN & TREES 04/17 | -130.44
DEBIT | 2017-04-18 00:00:00 | Online Payment [PHONE] To CHASE CARDMEMBER SERVICES 04/18 | -48.57
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To BLUE RIBBON LINEN SUPPLY 04/19 | -277.44
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To BLUE RIBBON LINEN SUPPLY 04/19 | -383.21
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To CLEAN RITE 04/19 | -85
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To CLEAN RITE 04/19 | -85
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To CLEAN RITE 04/19 | -85
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To CLEAN RITE 04/19 | -85
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To CLEAN RITE 04/19 | -85
DEBIT | 2017-04-19 00:00:00 | Online Payment [PHONE] To BARGREEN ELLINGSON 04/19 | -431.76
DEBIT | 2017-04-28 00:00:00 | Online Payment [PHONE] To IMPACT BUSINESS PRODUCTS 04/28 | -42.39
CREDIT | 2017-04-25 00:00:00 | [NAME] from CHK ...9037 transaction#: [PHONE] | 2500
DEBIT | 2017-04-03 00:00:00 | [NAME] to  CHK ...0977 transaction#: [PHONE] 04/03 | -1188
DEBIT | 2017-04-03 00:00:00 | [NAME] to  CHK ...0977 transaction#: [PHONE] 04/03 | -199.81
DEBIT | 2017-04-28 00:00:00 | [NAME] to  CHK ...0977 transaction#: [PHONE] 04/28 | -524.05
DEBIT | 2017-04-04 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/04 | -956.56
DEBIT | 2017-04-05 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/05 | -1000
DEBIT | 2017-04-05 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/05 | -1000
DEBIT | 2017-04-06 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/06 | -1000
DEBIT | 2017-04-11 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/11 | -1683.6
DEBIT | 2017-04-11 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/11 | -573.24
DEBIT | 2017-04-12 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/12 | -215.6
DEBIT | 2017-04-17 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/17 | -3559.82
DEBIT | 2017-04-19 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/19 | -600
DEBIT | 2017-04-21 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/21 | -283.69
DEBIT | 2017-04-24 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/24 | -192.37
DEBIT | 2017-04-24 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/24 | -108.43
DEBIT | 2017-04-24 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/24 | -3345.77
DEBIT | 2017-04-26 00:00:00 | [NAME] to CHK ...0977 transaction#: [PHONE] 04/26 | -1570
DEBIT | 2017-04-17 00:00:00 | [NAME] to CHK ...5125 transaction#: [PHONE] 04/17 | -100
DEBIT | 2017-04-05 00:00:00 | SERVICE CHARGES FOR THE MONTH OF [NAME] | -20
DEBIT | 2017-04-26 00:00:00 | SPCENVIRONMENTAL SPCENVR    039493111943992 WEB ID: [PHONE] | -278.24
DEBIT | 2017-04-05 00:00:00 | SPOKANE WATER 3  UTILITY    8302335         CCD ID: [PHONE] | -15.3
DEBIT | 2017-04-25 00:00:00 | STORED [NAME]CCD ID: [PHONE] | -2.39
CREDIT | 2017-04-18 00:00:00 | STORED [NAME]CCD ID: [PHONE] | 18.28
CREDIT | 2017-04-11 00:00:00 | STORED [NAME]CCD ID: [PHONE] | 37.79
DEBIT | 2017-04-04 00:00:00 | STORED [NAME]CCD ID: [PHONE] | -3.79
CREDIT | 2017-04-04 00:00:00 | STORED [NAME]CCD ID: [PHONE] | 7.97
DEBIT | 2017-04-21 00:00:00 | TRIPLE B CORP D/ [NAME]PPD ID: [PHONE] | -80.69
DEBIT | 2017-04-07 00:00:00 | TRIPLE B CORP D/ [NAME]PPD ID: [PHONE] | -116.14
DEBIT | 2017-04-27 00:00:00 | WASTE MANAGEMENT INTERNET   043000098373624 WEB ID: [PHONE] | -234.76