Spreadsheet: 274722d1383206381-how-to-apply-the-function-for-match-and-index-lookup
Sheet: Tables

 | Customers
 | Customer Code | ACCO | AFON | ANDER | ASHW | [NAME] | BENN | BERG1 | BERG2 | BERT | BRAU | BROW1 | CAMI | CART | CARV | CAST | CHAN1 | CITE | CRAM | CROW | CRUZ | DEVO | DEWE | DOMI | FERN1 | FEUE | FONS | FRAN | FRES | FREY | GONZ | HAR | HARN | HENRI | HOLZ | HUTI | IBSE | IZQU | [NAME] | [NAME] | KART | KLOS | KOSK | KUMA | LABR | [NAME] | LATI | LEBI | LIME | LINC | MANC | MCKE | MEND | MESS | MOOS | MORE | MORO | MULL | NAGY | NIXO | OTTLI | PACA | PAOL | PARE | PERE | PETR1 | PETT1 | PFAL | PHIL | PIPP | PONT | RANC | RODR | ROEL | ROUL | ROVE | SAAV | SAVE | SCHM | SIMP | SNYD | SOMM | STEE | TANN | TONI | TRUJ | WANG1 | WILS1 | WILS2 | WONG1 | YORR
 | Customer Name | PAUL ACCORTI | PEDRO AFONSO | MARIA ANDERS | VICTORIA ASHWORTH | BERNARDO BATISTA | HELEN BENNETT | CHRISTINA BERGLUND | [NAME] | MARIE BERTRAND | ART BRAUNSCHWEIGER | [NAME] | [NAME] | PASCALE CARTRAIN | LÚCIA CARVALHO | ISABEL DE CASTRO | FRANCISCO CHANG | FRÉDÉRIQUE CITEAUX | PHILIP CRAMER | SIMON CROWTHER | [NAME] | [NAME] | [NAME] | ANABELA DOMINGUES | GUILLERMO [NAME] | ALEXANDER FEUER | ANDRÉ FONSECA | PETER FRANKEN | JEAN FRESNIÈRE | JOSÉ PEDRO FREYRE | [NAME] | THOMAS HARDY | [NAME] | [NAME] | [NAME] | SERGIO GUTIÉRREZ | PALLE IBSEN | FELIPE IZQUIERDO | [NAME] | KARIN JOSEPHS | MATTI [NAME] | HORST KLOSS | PIRKKO KOSKITALO | HARI KUMAR | [NAME] | MARIA LARSSON | YOSHI LATIMER | [NAME] | [NAME] LIMEIRA | [NAME] | YVONNE MONCADA | PATRICIA MCKENNA | [NAME] | RENATE MESSNER | HANNA MOOS | ANTONIO MORENO | MAURIZIO MORONI | RITA MULLET | HELVETIUS NAGY | LIZ [NAME] | SVEN OTTLIEB | [NAME] | MIGUEL ANGEL PAOLINO | PAULA PARENTE | MANUEL PEREIRA | JYTTE PETERSEN | DOMINIQUE PERRIER | HENRIETTE PFALZHEIM | RENE PHILLIPS | GEORG PIPPS | MARIO PONTES | MARTINE RANCÉ | LINO RODRIGUEZ | DIEGO ROEL | ANNETTE ROULET | GIOVANNI ROVELLI | EDUARDO SAAVEDRA | [NAME] | CARINE SCHMITT | PATRICIO SIMPSON | HOWARD SNYDER | MARTÍN SOMMER | JOHN STEEL | YOSHI TANNAMURI | DANIEL TONINI | ANA TRUJILLO | YANG WANG | FRAN WILSON | PAULA WILSON | [NAME] | [NAME]
 | Address | 333 [NAME] | 23 Louis Rd | 57 Obere St | 12 Fauntleroy Circus | 23 Louis Rd | 24 Kléber Place | 8 Berguve Rd | 18 Fall Crescent | 12 Fauntleroy Circus | PO  Box 555 | 12  [NAME] | 84 Asling Street | 255 Boulevard Tirou | 12  [NAME] | 29 Hope Rd | 999 Sierras de Granada | 24 Kléber Place | C/ 67 Araquil Crescent | 24 Kléber Place | 92 Long Rd | 35 King [NAME] | 35 King [NAME] | 34 [NAME] | 333 [NAME] | 57 Forest Street | 12  [NAME] | 23 Tsawassen Blvd | 43 St . Laurent Drive | 23 Louis Rd | 23 Louis Rd | 120 [NAME]. | 120 [NAME]. | 18 Fall Crescent | 18 Loing Way | 67 [NAME] | 18 Loing Way | 12  [NAME] | 25 rue Lauriston St | 187 [NAME]. | PO  Box 1212 | 21 Walser Way | 90 Wadhurst Rd. | 90 Wadhurst Rd. | 67 [NAME] | 12 Bouch St | 8 Berguve Rd | 12 Bouch St | 15 Smith Street | 23 Tsawassen Blvd | C/ 67 Araquil Crescent | 57 Forest Street | 6 Kirchgasse Street | 999 Sierras de Granada | 57 Forest Street | 213 Mataderos  Rd | 43 St . Laurent Drive | 187 [NAME] | 15 Smith Street | Suite 2, 89 [NAME] | 21 Walser Way | 187 [NAME]. | 90 Wadhurst Rd. | 34 [NAME] | 2222 Constitute Ave | 34 [NAME] | 25 rue Lauriston St | 23 Tsawassen Blvd | 12 Bouch St | 999 Sierras de Granada | 213 Mataderos  Rd | C/ 67 Araquil Crescent | 999 Sierras de Granada | 86 Moralz Rd | 23 Tsawassen Blvd | 67 [NAME] | 29 Hope Rd | 84 Asling Street | 12 Fauntleroy Circus | 333 [NAME] | 21 Walser Way | C/ 67 Araquil Crescent | 333 [NAME] | 12 Fauntleroy Circus | 12 Bouch St | 2222 Constitute Ave | 29 Hope Rd | 21 Walser Way | 35 King [NAME] | 55 Grizzly Peak Rd | 29 Hope Rd
 | Suburb | [NAME] | [NAME] | Footscray | Melbourne | Kamona | Sydney | Dandenong | Spring Hill | Dandenong | Sydney | Frankston | Sydney | Brighton | Kadina | Green Point | Spring Hill | Newport | Brisbane | Melbourne | Sydney | Newport | Brisbane | [NAME] | Sydney | Port Melbourne | Sydney | Melbourne | [NAME] | Frankston | Melbourne | [NAME] | Canberra | Brisbane | Brisbane | Sydney | Melbourne | Brisbane | Caulfield | Newport | Sydney | Brisbane | Sydney | Brisbane | Orange | Newport | Dundee | Orange | Brighton | Port Melbourne | Sydney | Frankston | Melbourne | Sydney | Sydney | Melbourne | Caulfield | [NAME] | Brisbane | Melbourne | Albury | Melbourne | Sydney | Melbourne | Brisbane | Albury | Caulfield | [NAME] | Newport | Melbourne | Melbourne | [NAME] | Dandenong | Dandenong | Port Melbourne | Orange | Melbourne | Dandenong | Sydney | Albury | Doncaster | [NAME] | Frankston | Spring Hill | Melbourne | [NAME] | Sydney | Sydney | Melbourne | Brisbane | Albury
 | State | NSW | VIC | VIC | VIC | TAS | NSW | VIC | QLD | VIC | NSW | VIC | NSW | SA | SA | NSW | QLD | VIC | QLD | VIC | NSW | VIC | QLD | VIC | NSW | VIC | NSW | VIC | VIC | VIC | VIC | VIC | ACT | QLD | QLD | NSW | VIC | QLD | VIC | VIC | NSW | QLD | NSW | QLD | NSW | VIC | NSW | NSW | SA | VIC | NSW | VIC | VIC | NSW | NSW | VIC | VIC | VIC | QLD | VIC | NSW | VIC | NSW | VIC | QLD | NSW | VIC | VIC | VIC | VIC | VIC | VIC | VIC | VIC | VIC | NSW | VIC | VIC | NSW | NSW | VIC | VIC | VIC | QLD | VIC | VIC | NSW | NSW | VIC | QLD | NSW
 | Postcode | 2787 | 3013 | 3011 | 3000 | 7261 | 2000 | 3198 | 4078 | 3198 | 2000 | 3198 | 2000 | 5004 | 5554 | 2428 | 4078 | 3015 | 4000 | 3000 | 2000 | 3015 | 4000 | 3013 | 2000 | 3296 | 2000 | 3000 | 3013 | 3198 | 3000 | 3013 | 2601 | 4000 | 4000 | 2000 | 3000 | 4000 | 3184 | 3015 | 2000 | 4000 | 2000 | 4000 | 2118 | 3015 | 2370 | 2118 | 5004 | 3296 | 2000 | 3198 | 3000 | 2000 | 2000 | 3000 | 3184 | 3013 | 4000 | 3000 | 2867 | 3000 | 2000 | 3000 | 4000 | 2867 | 3184 | 3013 | 3015 | 3000 | 3000 | 3013 | 3198 | 3198 | 3296 | 2118 | 3000 | 3198 | 2000 | 2867 | 3478 | 3013 | 3198 | 4078 | 3000 | 3128 | 2000 | 2000 | 3000 | 4000 | 2867
 | Phone | (02) 9784 8460 | (03) 9787 4545 | (03) 9555 4545 | (03) 9200 4453 | (03) 9555 4252 | (02) 9555 8888 | (03) 9123 4565 | (07) 3784 6565 | (03) 9555 0091 | (02) 9654 8460 | (03) 9345 4545 | (02) 9654 8460 | (08) 6784 4545 | (03) 9555 1189 | (02) 9657 0123 | (04) 4878 5454 | (03) 9312 1212 | (07) 5550 9876 | (03) 9555 7733 | (02) 9654 8460 | (03) 9555 0297 | (07) 4283 2951 | (03) 9555 0091 | (02) 9657 0123 | (03) 4202 3176 | (02) 9654 8460 | (03) 9654 4545 | (03) 9555 8054 | (03) 9555 8282 | (03) 9555 0091 | (03) 9555 7788 | (06) 555 1340 | (07) 4656 3801 | (07) 4108 9345 | (02) 9654 8460 | (03) 9600 4453 | (07) 7283 2951 | (03) 9555 0091 | (03) 9318 5678 | (02) 9654 8460 | (07) 3987 4545 | (02) 9654 8460 | (07) 3987 0101 | (02) 6345 4978 | (03) 3787 6565 | (03) 9555 6874 | (02) 6354 7878 | (03) 9555 3412 | (03) 9654 4545 | (02) 9135 5333 | (03) 92967 542 | (03) 9654 4545 | (02) 9602 5984 | (02) 9654 8460 | (03) 9655 1212 | (03) 9200 4453 | (03) 9555 0091 | (206) 555 8257 | (03) 9555 0091 | (02) 2354 4123 | (03) 9555 0091 | (02) 9654 8460 | (03) 9555 8122 | (07) 3283 2951 | (02) 9654 8460 | (03) 9555 0091 | (03) 9200 4453 | (03) 9555 0091 | (03) 9555 0091 | (03) 9555 0091 | (03) 9200 4453 | (03) 9203 4559 | (03) 9654 4545 | (03) 9555 0091 | (063) 6445 0230 | (03) 9203 4578 | (03) 9784 4545 | (02) 9654 8460 | (02) 3787 6565 | (503) 555 7555 | (03) 9454 4545 | (03) 9555 0091 | (07) 4283 2951 | (03) 3787 6565 | (03) 9784 5454 | (02) 9654 8460 | (02) 9555 9573 | (03) 9555 0091 | (07) 3784 6565 | (02) 9555 5938
 | Notes | Regular Customer | 10% Discount | Regular Customer |  | 10% Discount | Regular Customer |  |  |  | Regular Customer | 10% Discount |  |  | Regular Customer |  | 10% Discount |  |  |  | 10% Discount | 10% Discount | 10% Discount | 10% Discount | 10% Discount |  |  | 10% Discount
 | ID Supplied? | NO | YES | YES | NO | YES | NO | YES | YES | YES | YES | YES | YES | NO | YES | NO | YES | YES | YES | YES | YES | NO | YES | YES | YES | NO | YES | YES | YES | NO | NO | YES | NO | YES | NO | YES | YES | YES | NO | NO | NO | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | NO | NO | YES | YES | YES | YES | YES | NO | YES | NO | YES | YES | YES | YES | NO | YES | YES | YES | YES | NO | YES | YES | YES | NO | YES | YES | YES | YES | NO | YES | YES | YES | NO | YES | YES | YES | YES
 | Videos
 | Video Code | 3185H556 | 678H4 | DM1456 | G123 | G6745 | GC81510 | R1120 | T100960
 | Video Name | The Road to Hollywood | Abba on stage | Ice Racing Championship | Princess [NAME] | Ride-Ho | Gourmet Cooking Tour | Your mind and Body | Wishbone - Hercules Unleashed
 | Cost each | 15 | 12.5 | 23 | 39.95 | 20.5 | 29.5 | 14.85 | 16.5
 | Type | Musicals | Musical | Sport | Western | Western | New Release | Documentary | Horror