Spreadsheet: 217777d1362176235-complex-vlook-and-or-index-formula-question-expert-advice-needed-excel-forum-sample-1v3
Sheet: Roster

Employee No | Name | Company | Level | Location | Alliant LCAT | LCAT Code | Burdened Cost | [NAME] (Pre-May) | [NAME] (Post-May) | Start Date | End Date | LOE | Role | Assessment Cycle | Senior Associate | RC
545170 | [NAME], [NAME] | [NAME] | Senior Consultant | Stafford | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
528665 | Adams, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
547695 | Adimulam, Vinod | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | Ahmed, [NAME] | Blue Canopy | Information Technology Specialist | Remote |  |  |  |  |  |  |  | 1
 | Akbar, [NAME] | Blue Canopy | Software Development Specialist | [NAME] |  |  |  |  |  |  |  | 1
533015 | Ascione, [NAME] | [NAME] | Lead Associate | Stafford | Systems Engineer |  |  |  |  |  |  | 0.75
 | Attar, Mazharullah | The Goal | Integration Lead | [NAME] |  |  |  |  |  |  |  | 1
 | Austin, Chantè | Blue Canopy | Project Controls Engineer | [NAME] |  |  |  |  |  |  |  | 1
526380 | [NAME], [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | Awetahegne, [NAME] | Blue Canopy | Project Manager | Stafford |  |  |  |  |  |  |  | 1
514904 | [NAME], [NAME] | [NAME] | Associate | Remote | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 0.1
 | Banda, [NAME] | Blue Canopy | Information Technology Specialist | McLean |  |  |  |  |  |  |  | 1
 | Bhattacharya, [NAME] | The Goal | Integration Lead | McLean |  |  |  |  |  |  |  | 1
 | Bhupathiraju, [NAME] | The Goal | Software Development Expert | [NAME] |  |  |  |  |  |  | 2013-03-31 00:00:00 | 0
526815 | Blackmer, [NAME] | [NAME] | Lead Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
502817 | Block, Gregory | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
561901 | [NAME], [NAME] | [NAME] | Senior Consultant | Stafford | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
547234 | Bonthula, Sridhar | [NAME] | Associate | McLean | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | Bouchoux, [NAME] | Blue Canopy | Project Manager | Stafford |  |  |  |  |  |  |  | 1
 | Boyle, Maura | IronWorks | Business Requirements Expert | Remote |  |  |  |  |  |  |  | 0.25
557752 | Brown, Constance | [NAME] | Consultant | McLean | Applications Developer (Journeyman) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | Blue Canopy | Technical Solutions Expert | Remote |  |  |  |  |  |  |  | 1
525536 | [NAME], [NAME] | [NAME] | Principal | Stafford | Program Manager |  |  |  |  |  |  | 0.8
547177 | Burdick, [NAME] | [NAME] | Associate | McLean | Subject Matter Expert (Senior) |  |  |  |  |  | 2013-04-30 00:00:00 | 0
 | Burugu, [NAME] | Blue Canopy | Systems [NAME] | [NAME] |  |  |  |  |  |  |  | 1
557543 | Caludis, [NAME] | [NAME] | Senior Consultant | Stafford | Quality Assurance Specialist (Entry Level) |  |  |  |  |  |  | 1
546357 | [NAME], [NAME] | [NAME] | Senior Consultant | Stafford | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
533888 | Chauhan, Diksha | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | Chigullapally, Srilaxmi | Blue Canopy | Software Development Expert | McLean |  |  |  |  |  |  |  | 1
 | Coates, Woody | IronWorks | Process Engineer | Remote |  |  |  |  |  |  |  | 0.5
550423 | Coyne, My | [NAME] | Associate | Stafford | Systems Engineer |  |  |  |  |  |  | 1
 | Craze, [NAME] | IronWorks | Quality Assurance Specialist | Remote |  |  |  |  |  |  |  | 1
548739 | [NAME], [NAME] | [NAME] | Lead Associate | Stafford | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 1
 | Damaraju, Sarita | Blue Canopy | Information Technology Expert | Stafford |  |  |  |  |  |  |  | 1
525109 | Dang, [NAME] | [NAME] | Lead Associate | McLean | Business Systems Analyst |  |  |  |  |  |  | 1
 | [NAME], [NAME] | IronWorks | Technical Solutions Expert | Remote |  |  |  |  |  |  |  | 1
550987 | Das, Ipsita | [NAME] | Senior Consultant | Remote | Applications Systems Analyst (Senior) |  |  |  |  |  | 2013-02-28 00:00:00 | 0
 | [NAME], [NAME] R | Blue Canopy | Technical Solutions Expert | Stafford |  |  |  |  |  |  |  | 1
 | D'Elia, [NAME] | The Goal | Information Technology Expert | McLean |  |  |  |  |  |  |  | 1
 | Desai, Parag | Blue Canopy | Technical Solutions Expert | Stafford |  |  |  |  |  |  |  | 1
550888 | [NAME], [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
537134 | [NAME], Nick | [NAME] | Associate | Remote | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 0.5
 | Dodly, [NAME] | The Goal | Information Technology Expert | McLean |  |  |  |  |  |  |  | 1
552673 | Donoghue, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | Downing, [NAME] | Blue Canopy | Senior Technical Lead | Stafford |  |  |  |  |  |  |  | 1
559664 | Eirich, [NAME] | [NAME] | Consultant | McLean | Applications Developer (Journeyman) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | IronWorks | Program Controls Expert | Remote |  |  |  |  |  |  |  | 0.1
551416 | Faruqi, [NAME] | [NAME] | Consultant | McLean | Quality Assurance Specialist (Journeyman) |  |  |  |  |  |  | 1
566428 | Fonseka, Tharanga | [NAME] | Consultant | Stafford | Quality Assurance Specialist (Journeyman) |  | 54.21 |  |  |  |  | 1
 | [NAME], Rachel | IronWorks | Business Requirements Expert | Remote |  |  |  |  |  |  | 2013-01-31 00:00:00 | 0
 | Garimella, Srivalli | Blue Canopy | Information Technology Specialist | McLean |  |  |  |  |  |  |  | 1
529551 | [NAME], [NAME] | [NAME] | Lead Associate | Stafford | Business Systems Analyst |  |  |  |  |  |  | 1
 | Gokul, [NAME] | Blue Canopy | Information Technology Specialist | McLean |  |  |  |  |  |  |  | 1
553630 | [NAME], [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | Information Gateways | Technical Solutions Expert | McLean |  |  |  |  |  |  |  | 1
 | Green, [NAME] | IronWorks | Senior Technical Lead | Remote |  |  |  |  |  |  |  | 0.25
523376 | Griffin, [NAME] | [NAME] | Senior Associate | Remote | Subject Matter Expert (Senior) |  |  |  |  |  |  | 0.05
535071 | Gutta, Girija | [NAME] | Senior Consultant | [NAME] | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | Haislmaier, [NAME] | The Goal | Information Technology Expert | Remote |  |  |  |  |  |  |  | 0.25
565616 | Harriman, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
54458 | Hermosilla, [NAME] | [NAME] | Senior Associate | Remote | Subject Matter Expert (Senior) |  | 204.57 |  |  |  |  | 0.05
 | [NAME], Greg | Blue Canopy | Business Requirements Expert | [NAME] |  |  |  |  |  |  |  | 1
535097 | [NAME], Amanda | [NAME] | Associate | McLean | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | Horowitz, [NAME] | IronWorks | Project Manager | Stafford |  |  |  |  |  |  |  | 1
560682 | [NAME], [NAME] | [NAME] | Consultant | McLean | Quality Assurance Specialist (Entry Level) |  |  |  |  |  |  | 1
 | Hussain, Deen | Blue Canopy | Quality Assurance Specialist | [NAME] |  |  |  |  |  |  | 2013-01-31 00:00:00 | 0
531578 | [NAME], Carlo | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | IdM Developer | Blue Canopy | Systems [NAME] | McLean |  |  |  |  |  |  |  | 1
516498 | [NAME], [NAME] | [NAME] | Lead Associate | Stafford | Project Manager |  |  |  |  |  |  | 0.5
 | [NAME], Jayesh | Blue Canopy | Software Development Task Lead | McLean |  |  |  |  |  |  |  | 1
557371 | [NAME], [NAME] | [NAME] | Consultant | McLean | Quality Assurance Specialist (Entry Level) |  |  |  |  |  |  | 1
 | Jones, [NAME] | IronWorks | Quality Assurance Specialist | Remote |  |  |  |  |  |  | 2013-01-31 00:00:00 | 0
503518 | Kaleemullah, [NAME] | [NAME] | Lead Associate | Stafford | Business Systems Analyst |  |  |  |  |  |  | 1
 | Kalifa, Kamal | Blue Canopy | Information Technology Engineer | McLean |  |  |  |  |  |  |  | 1
 | Kasanagottu, Kedarinath | Blue Canopy | Information Technology Expert | McLean |  |  |  |  |  |  |  | 1
 | Katrapati, Purna | Blue Canopy | Software Development Specialist | [NAME] |  |  |  |  |  |  |  | 1
561917 | Keohan, [NAME] | [NAME] | Senior Consultant | Stafford | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
 | Kiron, [NAME] | Blue Canopy | Information Technology Specialist | [NAME] |  |  |  |  |  |  |  | 1
 | Klein, [NAME] | Blue Canopy | Project Manager | Stafford |  |  |  |  |  |  |  | 1
 | Knowles, Nicole | IronWorks | Integration Lead | Stafford |  |  |  |  |  |  | 2013-01-31 00:00:00 | 0
 | Koduru, Chandra | Blue Canopy | Information Technology Specialist | McLean |  |  |  |  |  |  |  | 1
 | [NAME], Vamski | IronWorks | Software Development Specialist | Remote |  |  |  |  |  |  |  | 1
531646 | Kovats, [NAME] | [NAME] | Senior Consultant | Remote | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 0.5
541107 | [NAME] (Rajeswari), Sripriya | [NAME] | Associate | McLean | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | Blue Canopy | Software Development Specialist | [NAME] |  |  |  |  |  |  |  | 1
 | Kulkarni, Abhi | IronWorks | Technical Solutions Expert | Remote |  |  |  |  |  |  |  | 1
 | Kurapati, Babu | Blue Canopy | Information Technology Engineer | McLean |  |  |  |  |  |  |  | 1
 | [NAME], Sony | Blue Canopy | Information Technology Specialist | McLean |  |  |  |  |  |  |  | 1
 | [NAME], [NAME] | Blue Canopy | Integration Lead | Stafford |  |  |  |  |  |  |  | 0.8
 | Lemma, [NAME] | Blue Canopy | Information Technology Expert | McLean |  |  |  |  |  |  |  | 1
518676 | L'Etoile, [NAME] | [NAME] | Associate | McLean | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | Lindsey, Joshua | IronWorks | Architect | Remote |  |  |  |  |  |  |  | 1
 | Maddipati, Mrudula | Blue Canopy | Technical Solutions Expert | Stafford |  |  |  |  |  |  |  | 1
 | MaGann, [NAME] | Blue Canopy | Software Development Specialist | [NAME] |  |  |  |  |  |  |  | 1
 | Mahabal, Amit | Blue Canopy | Information Technology Expert | McLean |  |  |  |  |  |  |  | 1
 | Mahabal, Nitin | Information Gateways | Senior Technical Lead | Stafford |  |  |  |  |  |  |  | 1
 | Man, Doug | Blue Canopy | Systems Maintenance Engineer | [NAME] |  |  |  |  |  |  |  | 1
 | [NAME], Venkatesh | Blue Canopy | Project Manager | Stafford |  |  |  |  |  |  |  | 1
523829 | Marcinko, [NAME] | [NAME] | Lead Associate | Stafford | Business Systems Analyst |  |  |  |  |  |  | 1
534680 | Matarazzo, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | Mathur, Akhilesh | Blue Canopy | Senior Technical Lead | Stafford |  |  |  |  |  |  |  | 1
 | Muir, [NAME] | Blue Canopy | Business Requirements Specialist | Stafford |  |  |  |  |  |  |  | 1
 | Munagala, [NAME] | Blue Canopy | Software Development Task Lead | McLean |  |  |  |  |  |  |  | 1
 | [NAME], [NAME] | IronWorks | Quality Assurance Expert | Stafford |  |  |  |  |  |  |  | 1
536485 | Mutneja, [NAME] | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
535296 | Muvvala, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 0
537105 | Nayak, Vinaya | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
522957 | Ndunda, [NAME] | [NAME] | Associate | McLean | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 1
 | Negeri, [NAME] | Blue Canopy | Information Technology Engineer | McLean |  |  |  |  |  |  |  | 1
522557 | Newport, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
520739 | Ng, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | The Goal | Technical Solutions Expert | Stafford |  |  |  |  |  |  |  | 0.5
534211 | Palapa, Lokesh | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  | 2013-03-31 00:00:00 | 0
28308 | Pant, Vikram | [NAME] | Lead Associate | Remote | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 0.1
9601 | Patch, [NAME] | [NAME] | Senior Associate | Stafford | Subject Matter Expert (Senior) |  |  |  |  |  |  | 0.75
534281 | [NAME], Arapit | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | Blue Canopy | Quality Assurance Expert | Stafford |  |  |  |  |  |  |  | 1
 | Pendyala, Suresh | The Goal | Information Technology Specialist | [NAME] |  |  |  |  |  |  |  | 1
556288 | [NAME], [NAME] | [NAME] | Lead Associate | Stafford | Subject Matter Expert (Senior) |  |  |  |  |  |  | 1
535169 | Perzanowski, [NAME] | [NAME] | Senior Consultant | McLean | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
 | Pirro-Reid, Charlotte | Blue Canopy | Business Requirements Engineer | McLean |  |  |  |  |  |  |  | 1
505850 | [NAME], [NAME] | [NAME] | Lead Associate | Stafford | Systems Engineer |  |  |  |  |  |  | 0.5
509203 | [NAME], Niti | [NAME] | Lead Associate | McLean | Subject Matter Expert (Senior) |  |  |  |  |  |  | 1
 | Ramayanam, Babu Kumar | The Goal | Quality Assurance Expert | McLean |  |  |  |  |  |  | 2013-04-30 00:00:00 | 0
 | Ramchandran, Priya | Blue Canopy | Business Requirements Expert | [NAME] |  |  |  |  |  |  |  | 1
553893 | [NAME], [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | The Goal | Senior Technical Lead | [NAME] |  |  |  |  |  |  |  | 1
541453 | [NAME], George | [NAME] | Senior Consultant | McLean | Applications Systems Analyst (Journeyman) |  | 79.03 |  |  |  |  | 1
 | Sankati, [NAME] | The Goal | Quality Assurance Expert | McLean |  |  |  |  |  |  |  | 1
528799 | Santo [NAME], [NAME] | [NAME] | Associate | [NAME] | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
549778 | Saxena, Mayank | [NAME] | Associate | [NAME] | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
526059 | Schloer, [NAME] | [NAME] | Associate | Remote | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 0.5
 | Schneider, [NAME] | The Goal | Technical Solutions Expert | Stafford |  |  |  |  |  |  |  | 0.1
 | [NAME], Prashanthi | Blue Canopy | Quality Assurance Specialist | Remote |  |  |  |  |  |  |  | 1
534752 | [NAME], [NAME] | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | Shrader, [NAME] | IronWorks | Technical Solutions Expert | Remote |  |  |  |  |  |  |  | 0.05
521763 | [NAME], [NAME] | [NAME] | Lead Associate | Stafford | Business Systems Analyst |  |  |  |  |  |  | 1
 | Sippel, [NAME] | IronWorks | Integration Lead | Stafford |  |  |  |  |  |  | 2013-01-31 00:00:00 | 0
 | Smith, Antwane | Blue Canopy | Software Development Specialist | McLean |  |  |  |  |  |  |  | 1
27605 | Smith, Nadia | [NAME] | Senior Consultant | McLean | Project Manager |  |  |  |  |  |  | 0.8
546756 | [NAME], [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
552580 | Stith, [NAME] | [NAME] | Senior Consultant | McLean | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
 | Subravati, Vidyu | Blue Canopy | Quality Assurance Expert | [NAME] |  |  |  |  |  |  |  | 1
556464 | Suhaimi, [NAME] | [NAME] | Senior Consultant | McLean | Applications Systems Analyst (Journeyman) |  |  |  |  |  |  | 1
 | Suresh, [NAME] | The Goal | Integration Lead | [NAME] |  |  |  |  |  |  |  | 1
537068 | Sutton, [NAME] | [NAME] | Associate | Stafford | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
568346 | Taneja, Kusum | [NAME] | Associate | [NAME] | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 1
 | Thambusami, Raj | Information Gateways | Software Development Expert | McLean |  |  |  |  |  |  |  | 1
551336 | [NAME], Heather | [NAME] | Senior Consultant | McLean | Applications Systems Analyst (Journeyman) |  | 67.21 |  |  | 2013-02-25 00:00:00 |  | 1
23043 | [NAME], Julie | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
9524 | Tousignaut, [NAME] | [NAME] | Associate | [NAME] | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
559491 | Traynham, [NAME] | [NAME] | Senior Consultant | Remote | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 0.25
 | Trifu, [NAME] | IronWorks | Quality Assurance Specialist | Remote |  |  |  |  |  |  | 2013-02-28 00:00:00 | 0
551836 | [NAME], Helen | [NAME] | Senior Consultant | McLean | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | [NAME], [NAME] | The Goal | Architect | Remote |  |  |  |  |  |  |  | 0.1
 | Uttermann, [NAME] | Blue Canopy | Business Requirements Expert | Stafford |  |  |  |  |  |  |  | 1
 | Velamoor, Aravind | The Goal | Software Development Specialist | McLean |  |  |  |  |  |  |  | 1
546033 | Vemuri, [NAME] | [NAME] | Associate | McLean | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
 | [NAME], Meenakshi | The Goal | Software Development Expert | [NAME] |  |  |  |  |  |  |  | 1
 | Vinjamoori, [NAME] | The Goal | Software Development Expert | McLean |  |  |  |  |  |  |  | 1
558162 | Wade, [NAME] | [NAME] | Senior Consultant | Stafford | Applications Systems Analyst (Senior) |  |  |  |  |  |  | 1
509108 | Wakefield, [NAME] | [NAME] | Lead Associate | McLean | Subject Matter Expert (Journeyman) |  |  |  |  |  |  | 1
530614 | [NAME], [NAME] | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
23073 | [NAME], [NAME] | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  |  | 1
 | Yalavarthi, [NAME] | Blue Canopy | Software Development Engineer | [NAME] |  |  |  |  |  |  | 2013-02-28 00:00:00 | 0
 | Yates, [NAME] | The Goal | Software Development Specialist | McLean |  |  |  |  |  |  |  | 1
547048 | [NAME], Vamshi | [NAME] | Associate | McLean | Applications Systems Analyst (Master) |  |  |  |  |  | 2013-03-31 00:00:00 | 0