Spreadsheet: 869360d1715932478-need-help-in-capturing-data-with-vlookup-working-file-allocated-budget
Sheet: BudgetAllocation

Sub-Department | Position | Rating | Bonus Amount | Department Budget | Sub-Department Budget | Position Budget | Department | Share Percentage | Headcount |  | Overall Budget | 1000000
M1 | Senior Exec/Exec | Pass |  |  |  |  | Marketing | 0.5 | 10
M1 | Senior Exec/Exec | Good |  |  |  |  | Marketing | 0.3 | 3
M1 | Senior Exec/Exec | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M1 | Sup/TL | Pass |  |  |  |  | Marketing | 0.5 | 5
M1 | Sup/TL | Good |  |  |  |  | Marketing | 0.3 | 3
M1 | Sup/TL | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M1 | Manager | Pass |  |  |  |  | Marketing | 0.5 | 5
M1 | Manager | Good |  |  |  |  | Marketing | 0.3 | 3
M1 | Manager | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M2 | Senior Exec/Exec | Pass |  |  |  |  | Marketing | 0.5 | 10
M2 | Senior Exec/Exec | Good |  |  |  |  | Marketing | 0.3 | 3
M2 | Senior Exec/Exec | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M2 | Sup/TL | Pass |  |  |  |  | Marketing | 0.5 | 10
M2 | Sup/TL | Good |  |  |  |  | Marketing | 0.3 | 3
M2 | Sup/TL | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M2 | Manager | Pass |  |  |  |  | Marketing | 0.5 | 20
M2 | Manager | Good |  |  |  |  | Marketing | 0.3 | 5
M2 | Manager | Outstanding |  |  |  |  | Marketing | 0.2 | 2
M3 | Senior Exec/Exec | Pass |  |  |  |  | Marketing | 0.5 | 10
M3 | Senior Exec/Exec | Good |  |  |  |  | Marketing | 0.3 | 3
M3 | Senior Exec/Exec | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M3 | Sup/TL | Pass |  |  |  |  | Marketing | 0.5 | 10
M3 | Sup/TL | Good |  |  |  |  | Marketing | 0.3 | 3
M3 | Sup/TL | Outstanding |  |  |  |  | Marketing | 0.2 | 1
M3 | Manager | Pass |  |  |  |  | Marketing | 0.5 | 20
M3 | Manager | Good |  |  |  |  | Marketing | 0.3 | 5
M3 | Manager | Outstanding |  |  |  |  | Marketing | 0.2 | 2
S1 | Senior Exec/Exec | Pass |  |  |  |  | Support | 0.5 | 10
S1 | Senior Exec/Exec | Good |  |  |  |  | Support | 0.3 | 3
S1 | Senior Exec/Exec | Outstanding |  |  |  |  | Support | 0.2 | 1
S1 | Sup/TL | Pass |  |  |  |  | Support | 0.5 | 10
S1 | Sup/TL | Good |  |  |  |  | Support | 0.3 | 3
S1 | Sup/TL | Outstanding |  |  |  |  | Support | 0.2 | 1
S1 | Manager | Pass |  |  |  |  | Support | 0.5 | 20
S1 | Manager | Good |  |  |  |  | Support | 0.3 | 5
S1 | Manager | Outstanding |  |  |  |  | Support | 0.2 | 2
S2 | Senior Exec/Exec | Pass |  |  |  |  | Support | 0.5 | 10
S2 | Senior Exec/Exec | Good |  |  |  |  | Support | 0.3 | 3
S2 | Senior Exec/Exec | Outstanding |  |  |  |  | Support | 0.2 | 1
S2 | Sup/TL | Pass |  |  |  |  | Support | 0.5 | 10
S2 | Sup/TL | Good |  |  |  |  | Support | 0.3 | 3
S2 | Sup/TL | Outstanding |  |  |  |  | Support | 0.2 | 1
S2 | Manager | Pass |  |  |  |  | Support | 0.5 | 20
S2 | Manager | Good |  |  |  |  | Support | 0.3 | 5
S2 | Manager | Outstanding |  |  |  |  | Support | 0.2 | 2
S3 | Senior Exec/Exec | Pass |  |  |  |  | Support | 0.5 | 10
S3 | Senior Exec/Exec | Good |  |  |  |  | Support | 0.3 | 3
S3 | Senior Exec/Exec | Outstanding |  |  |  |  | Support | 0.2 | 1
S3 | Sup/TL | Pass |  |  |  |  | Support | 0.5 | 10
S3 | Sup/TL | Good |  |  |  |  | Support | 0.3 | 3
S3 | Sup/TL | Outstanding |  |  |  |  | Support | 0.2 | 1
S3 | Manager | Pass |  |  |  |  | Support | 0.5 | 20
S3 | Manager | Good |  |  |  |  | Support | 0.3 | 5
S3 | Manager | Outstanding |  |  |  |  | Support | 0.2 | 2
A1 | Senior Exec/Exec | Pass |  |  |  |  | [NAME] | 0.5 | 10
A1 | Senior Exec/Exec | Good |  |  |  |  | [NAME] | 0.3 | 3
A1 | Senior Exec/Exec | Outstanding |  |  |  |  | [NAME] | 0.2 | 1
A1 | Sup/TL | Pass |  |  |  |  | [NAME] | 0.5 | 10
A1 | Sup/TL | Good |  |  |  |  | [NAME] | 0.3 | 3
A1 | Sup/TL | Outstanding |  |  |  |  | [NAME] | 0.2 | 1
A1 | Manager | Pass |  |  |  |  | [NAME] | 0.5 | 20
A1 | Manager | Good |  |  |  |  | [NAME] | 0.3 | 5
A1 | Manager | Outstanding |  |  |  |  | [NAME] | 0.2 | 2
A2 | Senior Exec/Exec | Pass |  |  |  |  | [NAME] | 0.5 | 10
A2 | Senior Exec/Exec | Good |  |  |  |  | [NAME] | 0.3 | 3
A2 | Senior Exec/Exec | Outstanding |  |  |  |  | [NAME] | 0.2 | 1
A2 | Sup/TL | Pass |  |  |  |  | [NAME] | 0.5 | 10
A2 | Sup/TL | Good |  |  |  |  | [NAME] | 0.3 | 3
A2 | Sup/TL | Outstanding |  |  |  |  | [NAME] | 0.2 | 1
A2 | Manager | Pass |  |  |  |  | [NAME] | 0.5 | 20
A2 | Manager | Good |  |  |  |  | [NAME] | 0.3 | 5
A2 | Manager | Outstanding |  |  |  |  | [NAME] | 0.2 | 2
A3 | Senior Exec/Exec | Pass |  |  |  |  | [NAME] | 0.5 | 10
A3 | Senior Exec/Exec | Good |  |  |  |  | [NAME] | 0.3 | 3
A3 | Senior Exec/Exec | Outstanding |  |  |  |  | [NAME] | 0.2 | 1
A3 | Sup/TL | Pass |  |  |  |  | [NAME] | 0.5 | 10
A3 | Sup/TL | Good |  |  |  |  | [NAME] | 0.3 | 3
A3 | Sup/TL | Outstanding |  |  |  |  | [NAME] | 0.2 | 1
A3 | Manager | Pass |  |  |  |  | [NAME] | 0.5 | 20
A3 | Manager | Good |  |  |  |  | [NAME] | 0.3 | 5
A3 | Manager | Outstanding |  |  |  |  | [NAME] | 0.2 | 2