Spreadsheet: 91181d1290935096-taking-the-value-of-one-cell-based-on-the-information-on-an-adjacent-cell-excel-help
Sheet: Sheet1

Manager | Type | Client Name | Client fee | % of PF | End date product 1 | End date product 2 | End date product 3
[NAME] | Gold | Customer 1 | 92269.84550000001 | 0.02707448518192489 | - | - | -
[NAME] | Gold | Customer 2 | 42607.7945 | 0.0125022871185446 | - | - | -
[NAME] | Gold | Customer 3 | 42387.7065 | 0.01243770730633803 | - | - | -
[NAME] | Gold | Customer 4 | 34859.993 | 0.01022887118544601 | - | - | -
[NAME] | Gold | Customer 5 | 31085.9589 | 0.009121466813380281 | - | - | -
[NAME] | Gold | Customer 6 | 23278.4983 | 0.006830545275821597 | - | - | -
[NAME] | Silver | Customer 7 | 19735.7546 | 0.00579100780516432 | - | - | -
[NAME] | Silver | Customer 8 | 19041.7359 | 0.005587363820422535 | - | - | -
[NAME] | Silver | Customer 9 | 18087.8 | 0.005307453051643192 | - | - | -
[NAME] | Silver | Customer 10 | 16771.3773 | 0.004921178785211268 | - | - | -
[NAME] | Silver | Customer 11 | 14605.0244 | 0.004285511854460094 | - | - | -
[NAME] | Silver | Customer 12 | 13403.6308 | 0.003932990258215962 | - | - | -
[NAME] | Silver | Customer 13 | 12873.7515 | 0.003777509242957746 | - | - | -
[NAME] | Silver | Customer 14 | 10963.4045 | 0.003216961414319249 | - | - | -
[NAME] | Silver | Customer 15 | 10776.1 | 0.00316200117370892 | - | - | -
[NAME] | Silver | Customer 16 | 10134.9085 | 0.002973858127934273 | - | - | -
[NAME] | [NAME] | Customer 17 | 9900 | 0.002904929577464789 | - | - | -
[NAME] | [NAME] | Customer 18 | 9540.2355 | 0.002799364876760563 | 2012-02-01 00:00:00 | - | -
[NAME] | [NAME] | Customer 19 | 9000 | 0.002640845070422535 | 2011-11-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
[NAME] | [NAME] | Customer 20 | 8719.8676 | 0.002558646596244131 | 2012-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-02-08 00:00:00
[NAME] | [NAME] | Customer 21 | 8654 | 0.002539319248826291 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-01 00:00:00
[NAME] | [NAME] | Customer 22 | 8000 | 0.002347417840375587 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00
[NAME] | [NAME] | Customer 23 | 7998.2375 | 0.002346900674882629 | 2011-10-01 00:00:00 | - | 2011-08-01 00:00:00
[NAME] | [NAME] | Customer 24 | 7722.132000000001 | 0.002265883802816902 | 2012-02-01 00:00:00 | - | -
[NAME] | [NAME] | Customer 25 | 7111.446800000001 | 0.002086692136150235 | 2012-01-01 00:00:00 | 2011-08-01 00:00:00 | 2011-12-01 00:00:00
[NAME] | [NAME] | Customer 26 | 6884.0765 | 0.002019975498826291 | 2012-05-01 00:00:00 | - | -
[NAME] | [NAME] | Customer 27 | 5712.11 | 0.001676088615023474 | 2011-10-01 00:00:00 | - | -
[NAME] | [NAME] | Customer 28 | 5548.243100000001 | 0.001628005604460094 | 2011-09-01 00:00:00 | - | 2011-09-01 00:00:00
[NAME] | [NAME] | Customer 29 | 5017.9465 | 0.001472402142018779 | 2011-10-01 00:00:00 | - | -
[NAME] |  | Customer 30 | 4960 | 0.001455399061032864 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00
[NAME] |  | Customer 31 | 4960 | 0.001455399061032864 | - | - | -
[NAME] |  | Customer 32 | 4567.5525 | 0.001340244278169014 | 2011-10-01 00:00:00 | - | -
[NAME] |  | Customer 33 | 4276.5532 | 0.001254857159624413 | 2010-12-01 00:00:00 | - | -
[NAME] |  | Customer 34 | 4260.9844 | 0.001250288849765258 | - | 2011-06-01 00:00:00 | 2011-06-01 00:00:00
[NAME] |  | Customer 35 | 4138.5615 | 0.001214366637323944 | 2012-08-01 00:00:00 | 2011-12-01 00:00:00 | -
[NAME] |  | Customer 36 | 4000 | 0.001173708920187793 | 2011-11-01 00:00:00 | - | -
[NAME] |  | Customer 37 | 3605.35 | 0.001057907863849765 | 2011-11-01 00:00:00 | - | 2011-04-01 00:00:00
[NAME] |  | Customer 38 | 3285.236 | 0.0009639776995305165 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | -
[NAME] |  | Customer 39 | 3200.51 | 0.0009391167840375588 | 2011-07-01 00:00:00 | - | -
[NAME] |  | Customer 40 | 3153.059 | 0.000925193368544601 | 2011-04-01 00:00:00 | - | -
[NAME] |  | Customer 41 | 3138.62 | 0.000920956572769953 | 2011-05-01 00:00:00 | - | -
[NAME] |  | Customer 42 | 3011.624 | 0.0008836924882629108 | 2011-10-01 00:00:00 | - | -
[NAME] |  | Customer 43 | 2830.05 | 0.0008304137323943663 | 2011-02-01 00:00:00 | 2010-09-01 00:00:00 | 2011-04-01 00:00:00
[NAME] |  | Customer 44 | 2683 | 0.0007872652582159625 | 2011-09-01 00:00:00 | - | 2011-05-01 00:00:00
[NAME] |  | Customer 45 | 2572.4096 | 0.0007548150234741784 | - | 2012-11-01 00:00:00 | 2011-05-01 00:00:00
[NAME] |  | Customer 46 | 2545.459 | 0.0007469069835680752 | 2011-04-01 00:00:00 | - | -
[NAME] |  | Customer 47 | 2476.147 | 0.000726568955399061 | 2011-04-01 00:00:00 | - | -
[NAME] |  | Customer 48 | 2445.35 | 0.0007175322769953052 | 2011-11-01 00:00:00 | - | 2011-11-01 00:00:00
[NAME] |  | Customer 49 | 2424.2032 | 0.0007113272300469484 | 2011-08-01 00:00:00 | - | 2011-08-01 00:00:00
[NAME] |  | Customer 50 | 2266.2035 | 0.0006649658157276996 | - | 2011-08-03 00:00:00 | -
[NAME] |  | Customer 51 | 2100 | 0.0006161971830985916 | 2012-10-01 00:00:00 | - | -
[NAME] |  | Customer 52 | 2000 | 0.0005868544600938967 | - | - | 2011-11-01 00:00:00
[NAME] |  | Customer 53 | 1975 | 0.000579518779342723 | 2011-10-01 00:00:00 | 2011-10-01 00:00:00 | -
[NAME] |  | Customer 54 | 1946.6357 | 0.0005711959213615023 | 2011-06-01 00:00:00 | 2011-04-01 00:00:00 | 2011-06-01 00:00:00
[NAME] |  | Customer 55 | 1915.07 | 0.0005619336854460093 | 2011-11-01 00:00:00 | - | 2011-11-30 00:00:00
[NAME] |  | Customer 56 | 1827.98 | 0.0005363791079812207 | 2012-02-01 00:00:00 | - | -
[NAME] |  | Customer 57 | 1740.403 | 0.0005106816314553991 | 2011-11-01 00:00:00 | - | 2011-11-01 00:00:00
[NAME] |  | Customer 58 | 1511.3929 | 0.0004434838321596244 | 2011-04-01 00:00:00 | 2011-01-01 00:00:00 | 2011-04-29 00:00:00
[NAME] |  | Customer 59 | 1000 | 0.0002934272300469484 | 2011-10-01 00:00:00 | - | -
[NAME] |  | Customer 60 | 812.5 | 0.0002384096244131455 | - | 2011-01-01 00:00:00 | -
[NAME] |  | Customer 61 | 625 | 0.0001833920187793427 | 2011-08-01 00:00:00 | - | -
[NAME] |  | Customer 62 | 255.39 | 7.493838028169014e-05 | - | 2011-12-01 00:00:00 | 2012-10-01 00:00:00
[NAME] |  | Customer 63 | 250 | 7.335680751173709e-05 | - | - | -