Spreadsheet: 801691d1666301591-need-an-excel-formula-to-find-exact-result-from-in-proper-lookup-value-vlookup-vlookup_result
Sheet: Sheet1

NAMES | TEAMS | CODE | STREAM | TYPE | AUTO |  | Actual string |  |  | Granted Names | Team | Code
[NAME] (G) | Telecommunications) | 342411 | STSOL | 190, 407, 491 (S/T), TSS (S), 494 | TRA |  | [NAME] (G) |  | if string not complete one | ssa [NAME] (G) | Chemist | 234211 | I want formula in L:L & M:M
[NAME] (G) | Cafe or Restaurant Manager | 141111 | STSOL | 190, 407, 491 (S/T), TSS (S)*, 494 | VETASSESS |  | [NAME] (G) |  | if string not complete one | [NAME]) | Cafe or Restaurant Manager | 141111
[NAME] (G) | Camera Operator (Film, Television or Video) | 399512 | STSOL | 190, 407, 491 (S/T), TSS (S), 494 | TRA |  | [NAME] (G) |  | if string not complete one | RonaldCollins(G) | [NAME] | 331212
[NAME] (G) | [NAME] and Camping Ground Manager | 141211 | Regional | 407, 491 (S/T), TSS (M)*, 494 | VETASSESS |  | [NAME] (G) |  | if string not complete one | [NAME] (G) | Child Care Centre Manager | 134111
[NAME] (G) | Cardiac Technician | 311212 | STSOL | 190, 407, 491 (S/T), TSS (S), 494 | VETASSESS
[NAME] (G) | Cardiologist | 253312 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | MedBA
[NAME] (G) | Cardiothoracic Surgeon | 253512 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | MedBA
[NAME] (G) | Careers Counsellor | 272111 | STSOL | 190, 407, 491 (S/T), TSS (S), 494 | VETASSESS
[NAME] (G) | [NAME] | 331212 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | TRA
[NAME] (G) | [NAME] and [NAME] | 331211 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | TRA
[NAME] (G) | Cartographer | 232213 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | VETASSESS
[NAME] (G) | Chef | 351311 | MLTSSL | 186*, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M)*, 494 | TRA
[NAME] (G) | Chemical Engineer | 233111 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | Engineers Australia
[NAME] (G) | Chemical Plant Operator | removed | removed | removed | removed
[NAME] (G) | Chemist | 234211 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | VETASSESS
[NAME] (G) | Chemistry Technician | 311411 | STSOL | 190, 407, 491 (S/T), TSS (S), 494 | VETASSESS
[NAME] (G) | Chief Executive or Managing Director | 111111 | MLTSSL | 186*, 407, TSS (M)*, 494, PMSOL | AIM
[NAME] (G) | Chief Information Officer | 135111 | MLTSSL | 186, 407, TSS (M), 494 | ACS
[NAME] (G) | Child Care Centre Manager | 134111 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | TRA
[NAME] (G) | Chiropractor | 252111 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | CCEA
Christian Barnes II (G) | Cinema or Theatre Manager | 149912 | Regional | 407, 491 (S/T), TSS (M)*, 494 | VETASSESS
[NAME] (G) | Civil Engineer | 233211 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | Engineers Australia
[NAME] (G) | Civil Engineering Draftsperson | 312211 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | Engineers Australia/VETASSESS
[NAME] (G) | Civil Engineering Technician | 312212 | MLTSSL | 186, 189 (PT), 190, 407, 485 (GW),489 (F), 491 (S/T), TSS (M), 494 | VETASSESS