Spreadsheet: 887607d1737854006-vlookup-problem-sample-lookup-file
Sheet: Source

 | 1 |  |  |  |  | 20250116 | 20250116
ACTIVE SAFETY NZ LTD | 2 | 50 | 26611 | ACTIVE SAFETY NZ LTD |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
APPARELMASTER WAIKAT | 2 | 50 | 11820 | APPARELMASTER WAIKAT |  | POWDER CAP32 |  | REDBULL | REDBULL POWDER CO LT | 20012025
ATFAX LIMITED | 2 | 50 | 575 | ATFAX LIMITED |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
BAILEYS INSURANCE | 2 | 50 | 26772566 | BAILEYS INSURANCE |  | C32947 |  | REDBULL POWD | REDBULL POWDER CO LT | 20012025
BELLA VISTA MOTEL WH | 2 | 50 | 116000 | BELLA VISTA MOTEL WH |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
BUSINESS TECHNOLOGY | 2 | 50 | 619495 | BUSINESS TECHNOLOGY |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
CALL CARE ANSWER SER | 2 | 50 | 35075 | CALL CARE ANSWER SER |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
CAMBRIAN LODGE MOTEL | 2 | 50 | 67500 | CAMBRIAN LODGE MOTEL |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
CARLEYS TRANSPORT | 2 | 50 | 1452726 | CARLEYS TRANSPORT |  | 1197 |  | REDBULL | REDBULL POWDER CO LT | 20012025
CARTERS TYRE SERVICE | 2 | 50 | 577139 | CARTERS TYRE SERVICE | REDBULLP | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
CLASS ONE SERVICES | 2 | 50 | 60375 | CLASS ONE SERVICES |  |  |  | REDBULL POWD | REDBULL POWDER CO LT | 20012025
COMMERCIAL VEHICLE C | 2 | 50 | 10465 | COMMERCIAL VEHICLE C |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
CREST COMMERCIAL CLE | 2 | 50 | 91494 | CREST COMMERCIAL CLE |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
DUNEDIN CITY MOTORS | 2 | 50 | 16675 | DUNEDIN CITY MOTORS |  | 45113 |  | REDBULL | REDBULL POWDER CO LT | 20012025
DW GROUP LTD | 2 | 50 | 100000 | DW GROUP LTD |  | 1473417 |  | REDBULL | REDBULL POWDER CO LT | 20012025
EAST OTAGO AUTO LTD | 2 | 50 | 666035 | EAST OTAGO AUTO LTD |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
ECOLAB NEW ZEALAND | 2 | 50 | 183196 | ECOLAB NEW ZEALAND |  | NG |  | REDBULL MINI | REDBULL POWDER CO LT | 20012025
ENVIROWASTE SERVICES | 2 | 50 | 59386 | ENVIROWASTE SERVICES | AC 51632 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
FILTERPRO | 2 | 50 | 389657 | FILTERPRO |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
FINDLAYS DRYCLEANERS | 2 | 50 | 61893 | FINDLAYS DRYCLEANERS |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
FRENCH  CO | 2 | 50 | 12214 | FRENCH  CO |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
FUEL STORAGE | 2 | 50 | 5234292 | FUEL STORAGE |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
FUSION5 LTD | 2 | 50 | 2914101 | FUSION5 LTD |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
GLOBAL SURVEY LTD | 2 | 50 | 589473 | GLOBAL SURVEY LTD |  | REDBULL |  | ORD0000185 | REDBULL POWDER CO LT | 20012025
GOUGH TRANSPORT NZ L | 2 | 50 | 244548 | GOUGH TRANSPORT NZ L | 4003057 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
HERB MORGAN TYRES | 2 | 50 | 344689 | HERB MORGAN TYRES |  |  |  | REDBULL PWDR | REDBULL POWDER CO LT | 20012025
HTC SPECIALISED TOOL | 2 | 50 | 136367 | HTC SPECIALISED TOOL |  | TOP ROCK |  | REDBULL PWDR | REDBULL POWDER CO LT | 20012025
HYDRAULINK FLUID CON | 2 | 50 | 193349 | HYDRAULINK FLUID CON |  |  |  | REDBULL | REDBULL POWDER CO LT | 20012025
ICON LOGISTICS LTD | 2 | 50 | 831765 | ICON [NAME] |  |  |  | REDBUL01 | REDBULL POWDER CO LT | 20012025
IDEAL TRUCK SERVICES | 2 | 50 | 1332344 | IDEAL TRUCK SERVICES |  | 804 |  | REDBULL | REDBULL POWDER CO LT | 20012025
INSTITUTE OF QUARRYI | 2 | 50 | 1518000 | INSTITUTE OF QUARRYI |  |  |  | REDBULL | REDBULL POWDER CO LT | 20012025
KEY BUSINESS PARTNER | 2 | 50 | 684189 | KEY BUSINESS PARTNER |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
LIFE CARE CONSULTANT | 2 | 50 | 69000 | LIFE CARE CONSULTANT |  | R COMPANY |  | REDBULL PWDE | REDBULL POWDER CO LT | 20012025
LUBRICANTS NZ LTD | 2 | 50 | 271239 | LUBRICANTS NZ LTD |  | 1 |  | REDBU | REDBULL POWDER CO LT | 20012025
M B CURTIS | 2 | 50 | 876300 | M B CURTIS |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
MAINFREIGHT DCB | 2 | 50 | 1844785 | MAINFREIGHT DCB |  |  |  | REDPOWAKL | REDBULL POWDER CO LT | 20012025
MAINLAND DRIVING SCH | 2 | 50 | 120440 | MAINLAND DRIVING SCH |  |  |  | REDBULL | REDBULL POWDER CO LT | 20012025
MCKEAN MOTORS | 2 | 50 | 301875 | MCKEAN MOTORS |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
MINISTRY FOR PRIMARY | 2 | 50 | 15803 | MINISTRY FOR PRIMARY |  |  |  | 3595000 | REDBULL POWDER CO LT | 20012025
MOBILE AUTO ELECTRIC | 2 | 50 | 242041 | MOBILE AUTO ELECTRIC |  | ER |  | REDBULLPOWD | REDBULL POWDER CO LT | 20012025
MOTION NZ LTD | 2 | 50 | 300217 | MOTION NZ LTD | AC 2145 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
NAVMAN WIRELESS NEW | 2 | 50 | 439990 | NAVMAN WIRELESS NEW | 159391 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
NORTH ALBANY MOTORS | 2 | 50 | 91439 | NORTH ALBANY MOTORS | 83244 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
NZSAFETYBLACKWOODS | 2 | 50 | 440671 | NZSAFETYBLACKWOODS |  | B029271 |  | REDBULL | REDBULL POWDER CO LT | 20012025
OFFICE MAX | 2 | 50 | 67922 | OFFICE MAX |  |  |  | RMS | REDBULL POWDER CO LT | 20012025
OIL IMPORTS LTD | 2 | 50 | 1462490 | OIL IMPORTS LTD | AC 827 | TOPROCK |  | REDBULL | REDBULL POWDER CO LT | 20012025
PACIFICA SHIPPING | 2 | 50 | 1527603 | PACIFICA SHIPPING |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PASSRITE HAMILTON | 2 | 50 | 65378 | PASSRITE HAMILTON |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PB TECH | 2 | 50 | 21848 | PB TECH | RAY123091 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PDQ PRINT LTD | 2 | 50 | 44850 | PDQ PRINT LTD | 1275 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PENGELLYS LTD | 2 | 50 | 56658 | PENGELLYS LTD |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PEOPLE SOLUTIONZ LTD | 2 | 50 | 24150 | PEOPLE SOLUTIONZ LTD |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PLASBACK | 2 | 50 | 309350 | PLASBACK | REDB0001 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
POKENO AUTO CENTRE | 2 | 50 | 71460 | POKENO AUTO CENTRE |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
PUKEKOHE TOYOTA | 2 | 50 | 157955 | PUKEKOHE TOYOTA |  | REDBULL |  | 11314D | REDBULL POWDER CO LT | 20012025
QUANTUM CONTROLS LTD | 2 | 50 | 519800 | QUANTUM CONTROLS LTD |  | 7 |  | REDBULL | REDBULL POWDER CO LT | 20012025
R  M ENGINEERING LTD | 2 | 50 | 548013 | R  M ENGINEERING LTD |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
REBULLRMSMACRAES | 2 | 50 | 425747 | REBULLRMSMACRAES | MACRAES | RMS |  | REDBULL | REDBULL POWDER CO LT | 20012025
RENTOKIL INITIAL LTD | 2 | 50 | 29646 | RENTOKIL INITIAL LTD | 850000541 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
RILEE SIGNS LTD | 2 | 50 | 229425 | RILEE SIGNS LTD |  |  |  | REDBULL | REDBULL POWDER CO LT | 20012025
ROZENDAAL HEAVY HAUL | 2 | 50 | 273442 | ROZENDAAL HEAVY HAUL |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
SAFETY  APPAREL LTD | 2 | 50 | 228952 | SAFETY  APPAREL LTD | 6460 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
SHEFFIELD STREET AUT | 2 | 50 | 99124 | SHEFFIELD STREET AUT |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
TDDA | 2 | 50 | 60099 | TDDA |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
TERRA INDUSTRIAL NEW | 2 | 50 | 94431 | TERRA INDUSTRIAL NEW | 3015242 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
WAE ENGINEERING LTD | 2 | 50 | 47046 | WAE ENGINEERING LTD |  | CN 2657 |  | REDBULL | REDBULL POWDER CO LT | 20012025
WAIPIPI SERVICES LIM | 2 | 50 | 658939 | WAIPIPI SERVICES LIM |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
WAITEMATA TRADING LT | 2 | 50 | 70235 | WAITEMATA TRADING LT |  | REDBULL PWDR |  | M10-CCB1939 | REDBULL POWDER CO LT | 20012025
WASTE MANAGEMENT NZ | 2 | 50 | 178548 | WASTE MANAGEMENT NZ |  |  |  | WM1012735 | REDBULL POWDER CO LT | 20012025
WINDSOR ENGINEERING | 2 | 50 | 3312000 | WINDSOR ENGINEERING | E306250 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
WOODLANDS MOTEL  CON | 2 | 50 | 31000 | WOODLANDS MOTEL  CON |  | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
WURTH NZ LIMITED | 2 | 50 | 28745 | WURTH NZ LIMITED | 120119643 | POWDER |  | REDBULL | REDBULL POWDER CO LT | 20012025
 | 3 | 72 | 66921325517