Spreadsheet: 682663d1592241561-vlookup-with-wildcard-not-working-example1750_1
Sheet: SHEET1

DATE | Description | Money in | Money Out | MONEY IN REASON | NEW FORMULA | PREVIOUS FORMULA (WHICH WORKS)
2020-03-30 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 200
2020-03-20 00:00:00 | CARD PAYMENT TO WILKO RETAIL LIMITED,1.50 GBP, RATE 1.00/GBP ON 18-03-2020 |  | 1.5 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-03-19 00:00:00 | CARD PAYMENT TO SELCO TRADING CTR,64.56 GBP, RATE 1.00/GBP ON 17-03-2020 |  | 50 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO THAMES WATER REF 123456789, MANDATE NO 0080 |  | 30 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO MORTGAGES 999999A, MANDATE NO 0085 |  | 150 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO BG SERVICES REF 987654159D, MANDATE NO 0079 |  | 30 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO REF GHTY7415, MANDATE NO 0059 |  | 300 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-03-11 00:00:00 | ARRANGED OVERDRAFT USAGE FEE |  | 20 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-02-19 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 3000 |  |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
2020-02-19 00:00:00 | MAINTAINING THE ACCOUNT - MONTHLY FEE |  | 5 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
 | CARD PAYMENT TO THAMES WATER,17.76 GBP, RATE 1.00/GBP ON 23-03-2020 |  | 17.76 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
 | CARD PAYMENT TO THAMES WATER,73.78 GBP, RATE 1.00/GBP ON 22-01-2020 |  | 73.78 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
 | CARD PAYMENT TO THAMES WATER,618.49 GBP, RATE 1.00/GBP ON 15-01-2020 |  | 618.49 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
 | CARD PAYMENT TO THAMES WATER,16.35 GBP, RATE 1.00/GBP ON 07-11-2019 |  | 16.35 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
 | CARD PAYMENT TO VIRGIN MEDIA PYMTS,89.98 GBP, RATE 1.00/GBP ON 24-09-2019 |  | 89.98 |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")
 |  |  |  |  |  |  | =IF(COUNT(D4);LOOKUP(2;1/SEARCH(" "&TRIM(SUBSTITUTE(SUBSTITUTE(SOUT1[KEY];".";" ");",";" "))&" ";" "&TRIM(SUBSTITUTE(SUBSTITUTE($B4;".";" ");",";" "))&" ");SOUT1[DESCRIPTION]);"")