chuckm4614
New Member
- Joined
- Jun 12, 2015
- Messages
- 4
Thanks in advance for the help and i hope this makes sense!
I have this info in a cell 06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
I need a formula that will find jcantrell and place the city that he works in in a different cell. So if H2 contains jcantrell - put "Atlanta" in cell J2. If H2 contains "rthompson" - Put Austin in J2....and so on
I should note that there are approximately 10 different names that could be in the H column.
Here's some of the data in that column:
06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to rthompson@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to rthompson@tradestar.com; 06/04/2015: Forwarded candidate to lmosher@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to RLudvigsen@tradestar.com; 06/04/2015: Status changed from No Status to Withdrawn; 06/04/2015: Status changed from Withdrawn to Reviewed
06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to cmcnair@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to lmosher@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
I have this info in a cell 06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
I need a formula that will find jcantrell and place the city that he works in in a different cell. So if H2 contains jcantrell - put "Atlanta" in cell J2. If H2 contains "rthompson" - Put Austin in J2....and so on
I should note that there are approximately 10 different names that could be in the H column.
Here's some of the data in that column:
06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to rthompson@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to rthompson@tradestar.com; 06/04/2015: Forwarded candidate to lmosher@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to RLudvigsen@tradestar.com; 06/04/2015: Status changed from No Status to Withdrawn; 06/04/2015: Status changed from Withdrawn to Reviewed
06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to jcantrell@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to cmcnair@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed
06/04/2015: Forwarded candidate to lmosher@tradestar.com; 06/04/2015: Status changed from No Status to Reviewed