JamesDLaurie
New Member
- Joined
- Oct 18, 2017
- Messages
- 2
Good Afternoon,
I need some assistance from the group, please... I need to generate a formula that will concatenate the left two characters in cell A2 with the first three characters in B2. Then take those results and compare them to a predetermined group of values and return a text response for a TRUE value or a different text response for a FALSE. I can handle the standard IF/THEN statement, where I'm struggling is having it compare to the list that I need to enter separately into the formula. See below:
<tbody>
</tbody><colgroup><col><col></colgroup>
I need some assistance from the group, please... I need to generate a formula that will concatenate the left two characters in cell A2 with the first three characters in B2. Then take those results and compare them to a predetermined group of values and return a text response for a TRUE value or a different text response for a FALSE. I can handle the standard IF/THEN statement, where I'm struggling is having it compare to the list that I need to enter separately into the formula. See below:
Project | Activity |
ABCDEFG | 123456789 |
DEFGHIJ | 987654321 |
LQYSXP | 784474215 |
<tbody>
</tbody><colgroup><col><col></colgroup>