Spreadsheet: 219375d1362741526-mulitple-results-from-a-vlookup-help-vlookup-multiple-jacc
Sheet: Full Fed list from Access (2)

Employer Number / Federation Initials | Initiative | Total | Result1 | Result2 | Result3 |  |  |  |  |  |  |  |  | Employer No | Federation | Field1
1003129 | Trainee allowance | 451 |  |  |  |  |  |  |  |  |  |  |  | 1000025 | NON | FD
1004760 | Trainee allowance | 2736.52 |  |  |  |  |  |  |  |  |  |  |  | 1000033 | NON | FD |  | http://www.excelforum.com/excel-formulas-and-functions/905396-mulitple-results-from-a-vlookup.html
1001241 | Trainee allowance | 1000 |  |  |  |  |  |  |  |  |  |  |  | 1000173 | FMB | FD
1006184 | Pre Apprenticeship | 4320.148496732027 |  |  |  |  |  |  |  |  |  |  |  | 1000262 | FMB | FD
1006184 | Shared Apprenticeship Payments | 526.6122448979592 |  |  |  |  |  |  |  |  |  |  |  | 1000289 | NON | FD
1006184 | Training allowance | 199.5 |  |  |  |  |  |  |  |  |  |  |  | 1000327 | NON | FD
1006885 | Trainee allowance | 115.2 |  |  |  |  |  |  |  |  |  |  |  | 1000386 | NON | FD
1006885 | Trainee allowance | 51.2 |  |  |  |  |  |  |  |  |  |  |  | 1000408 | FMB | FD
1008525 | Trainee allowance | 6591.62 |  |  |  |  |  |  |  |  |  |  |  | 1000424 | FMB | FD
1009229 | Trainee allowance | 3456.29 |  |  |  |  |  |  |  |  |  |  |  | 1000440 | NON | FD
1009555 | Trainee allowance | 822.16 |  |  |  |  |  |  |  |  |  |  |  | 1000491 | NON | FD
1011547 | Trainee allowance | 60 |  |  |  |  |  |  |  |  |  |  |  | 1000505 | OTH | FD
1011555 | Trainee allowance | 2917.56 |  |  |  |  |  |  |  |  |  |  |  | 1000513 | NON | FD
1014306 | Trainee allowance | 106.98 |  |  |  |  |  |  |  |  |  |  |  | 1000521 | NON | FD
1015956 | Specialist | 2100 |  |  |  |  |  |  |  |  |  |  |  | 1000548 | FMB | FD
8 | Pre Apprenticeship | 3383.355555555556 |  |  |  |  |  |  |  |  |  |  |  | 1000548 | NFB | FD
1017418 | Trainee allowance | 96 |  |  |  |  |  |  |  |  |  |  |  | 8 | NON | FD
1017426 | Trainee allowance | 280.5 |  |  |  |  |  |  |  |  |  |  |  | 8 | OTH | FD
1017566 | Trainee allowance | 1232.57 |  |  |  |  |  |  |  |  |  |  |  | 1000718 | DNK | FD
1019605 | Trainee allowance | 366.19 |  |  |  |  |  |  |  |  |  |  |  | 1000726 | NON | FD
1020057 | Inspire | 2000 |  |  |  |  |  |  |  |  |  |  |  | 1000769 | NON | FD
1022449 | Trainee allowance | 1789.28 |  |  |  |  |  |  |  |  |  |  |  | 1000777 | NON | FD
1022805 | Trainee allowance | 846.66 |  |  |  |  |  |  |  |  |  |  |  | 1000823 | NON | FD
1024725 | Trainee allowance | 3252.96 |  |  |  |  |  |  |  |  |  |  |  | 1000831 | FMB | FD
1025518 | Specialist | 300 |  |  |  |  |  |  |  |  |  |  |  | 1000890 | NON | FD
1025720 | Trainee allowance | 2151.7 |  |  |  |  |  |  |  |  |  |  |  | 1000955 | NON | FD
1027780 | Specialist | 1890 |  |  |  |  |  |  |  |  |  |  |  | 1000963 | NON | FD
1028026 | Trainee allowance | 228.8 |  |  |  |  |  |  |  |  |  |  |  | 1000971 | NON | FD
1028093 | Trainee allowance | 7888 |  |  |  |  |  |  |  |  |  |  |  | 1001012 | NON | FD
1029145 | Trainee allowance | 1819.16 |  |  |  |  |  |  |  |  |  |  |  | 1001020 | NON | FD
1029218 | Trainee allowance | 858 |  |  |  |  |  |  |  |  |  |  |  | 1001047 | NON | FD
1030069 | Trainee allowance | 5303.87 |  |  |  |  |  |  |  |  |  |  |  | 1001098 | NON | FD
1030441 | Trainee allowance | 280.8 |  |  |  |  |  |  |  |  |  |  |  | 1001101 | NON | FD
1031331 | Specialist | 1200 |  |  |  |  |  |  |  |  |  |  |  | 1001160 | OTH | FD
1031838 | Trainee allowance | 322.08 |  |  |  |  |  |  |  |  |  |  |  | 1001187 | NON | FD
1032787 | Trainee allowance | 682.12 |  |  |  |  |  |  |  |  |  |  |  | 1001195 | FMB | FD
1040372 | Trainee allowance | 321.9 |  |  |  |  |  |  |  |  |  |  |  | 1001217 | NON | FD
1042934 | Trainee allowance | 693.6 |  |  |  |  |  |  |  |  |  |  |  | 1001241 | FMB | FD
1042934 | Training allowance | 1423.6 |  |  |  |  |  |  |  |  |  |  |  | 1001241 | NFB | FD
1044722 | Trainee allowance | 1891 |  |  |  |  |  |  |  |  |  |  |  | 1001322 | NON | FD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1093105 | DNK | FD