Spreadsheet: 648395d1573034658-excel-look-up-formula-not-working-correctly-test-data
Sheet: Actuals

[NAME] | DESCRIPTION1 | CUSTOMERNUMBER | CUST_NM | ACCOUNT_ID | DESCRIPTION2 | MONTH_NUM | YEAR | EMP_SER_NUM | EMP_LAST_NAME | COUNTRY_CODE | WEEK_ENDING_DATE | EMP_COMPANY_CODE | SERVICETYPE | ACTIVITY_CD | SERVICELINE | [NAME] | CONTACTNAME | BILLING_CODE | BILLING_RATE | TOTAL_HRS | APPROVED_HRS | WORK_ITEM_ID | [NAME] | EMP_STATUS | OVERTIME_IND | EMP_LEVEL_CODE | PLAN_EXCHG_RT | LOCAL_COST | Actual FTE | Team | Expected output
xxxx | principle | 028350 | Platinum bridge | new | new 1 | 10 | 2019 | 123852 | SARKAR | 709 | 2019-10-25 00:00:00 | yyy | tc | TB01111 | BIS | xyz |  |  | 0 | 8 | 0 | DC001087 |  | TE | N | C | 0.6451613 | 390.4 |  |  | CustomTeam
xxxx | principle | 028350 | Platinum bridge | new | new 2 | 10 | 2019 | 05835V | Atul | 710 | 2019-10-25 00:00:00 | yyy | tc | TB01112 | BIS | xyz |  |  | 0 | 9 | 0 | MLSSS223 |  | RG | 3 | I | 45 | 4396.77 |  |  | Brno basis
xxxx | principle | 028350 | Platinum bridge | new | new 3 | 10 | 2019 | 05835V | Atul | 711 | 2019-10-25 00:00:00 | yyy | tc | TB01113 | BIS | xyz |  |  | 0 | 9 | 0 | MLSSS224 |  | RG | 3 | I | 45 | 4396.77 |  |  | Brno basis
xxxx | principle | 028350 | Platinum bridge | new | new 4 | 10 | 2019 | 021538 | AMRITA | 712 | 2019-10-25 00:00:00 | yyy | tc | TB01114 | BIS | xyz |  |  | 0 | 10 | 0 | MLGONAGN |  | RG | N | 2 | 45 | 8671.9 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 5 | 10 | 2019 | 597867 | SWARAJIt | 713 | 2019-10-25 00:00:00 | yyy | tc | TB01115 | BIS | xyz |  |  | 0 | 6 | 0 | MLGONAGN |  | RG | N | D | 45 | 12730.08 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 6 | 10 | 2019 | 000IWV | ZABIUDDIN MOHAMMED | 714 | 2019-10-25 00:00:00 | yyy | tc | TB01116 | BIS | xyz |  |  | 0 | 33 | 0 | MLSBNAGN |  | RG | N | 2 | 45 | 34340.46 |  |  | ML Basis
xxxx | principle | 028350 | Platinum bridge | new | new 7 | 10 | 2019 | 00639T | VIJAYA PRIYA M E | 715 | 2019-10-25 00:00:00 | yyy | tc | TB01117 | BIS | xyz |  |  | 0 | 10 | 0 | MLSBNAGN |  | RG | S | I | 45 | 217.2 |  |  | ML Basis
xxxx | principle | 028350 | Platinum bridge | new | new 8 | 10 | 2019 | 02206S | [NAME] | 716 | 2019-10-25 00:00:00 | yyy | tc | TB01118 | BIS | xyz |  |  | 0 | 11 | 0 | MLSMNAGN |  | RG | N | I | 45 | 5383.07 |  |  | RUNSAP
xxxx | principle | 028350 | Platinum bridge | new | new 9 | 10 | 2019 | 02206S | [NAME] | 717 | 2019-10-25 00:00:00 | yyy | tc | TB01119 | BIS | xyz |  |  | 0 | 17 | 0 | MLSSS074 |  | RG | N | I | 45 | 8319.29 |  |  | RUNSAP
xxxx | principle | 028350 | Platinum bridge | new | new 10 | 10 | 2019 | 003439 | Reka | 718 | 2019-10-25 00:00:00 | yyy | tc | TB01120 | BIS | xyz |  |  | 0 | 8 | 0 | MLSRNAGN |  | RG | Y | 1 | 45 | 7917.84 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 11 | 10 | 2019 | 003439 | Reka | 719 | 2019-10-25 00:00:00 | yyy | tc | TB01121 | BIS | xyz |  |  | 0 | 18 | 0 | MLSRNAGN |  | RG | 2 | 1 | 45 | 18283.14 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 12 | 10 | 2019 | 021538 | AMRITA | 720 | 2019-10-25 00:00:00 | yyy | tc | TB01122 | BIS | xyz |  |  | 0 | 10 | 0 | MLGONAGN |  | RG | N | 2 | 45 | 8671.9 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 13 | 10 | 2019 | 977144 | Bijoy | 721 | 2019-10-25 00:00:00 | yyy | tc | TB01123 | BIS | xyz |  |  | 0 | 45 | 0 | MLSRNAGN |  | RG | N | C | 45 | 51725.25 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 14 | 10 | 2019 | 01854I | Anik | 722 | 2019-10-25 00:00:00 | yyy | tc | TB01124 | BIS | xyz |  |  | 0 | 18 | 0 | MLGONAGN |  | RG | N | D | 45 | 31825.26 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 15 | 10 | 2019 | 473258 | Lavanya | 723 | 2019-10-25 00:00:00 | yyy | tc | TB01125 | BIS | xyz |  |  | 0 | 45 | 0 | MLGONAGN |  | RG | N | D | 45 | 79563.15 |  |  | NotSAPGov
xxxx | principle | 028350 | Platinum bridge | new | new 15 | 10 | 2019 | 0249F8 | R S GOURI | 709 | 2019-10-25 00:00:00 | yyy | tc | TB01125 | BIS | xyz |  |  | 0 | 15 | 0 | MLSRNAGN |  | RG | 1 | I | 45 | 7662.06 |  |  | SerMgt
xxxx | principle | 028350 | Platinum bridge | new | new 15 | 10 | 2019 | 00934M | KRISHNA CHALLA | 709 | 2019-10-18 00:00:00 | yyy | tc | TB01125 | BIS | xyz |  |  | 0 | 15 | 0 | MLGONAGN |  | RG | N | C | 45 | 17241.75 |  |  | Governance