brendaoc
New member
- Joined
- Jul 8, 2014
- Messages
- 9
- Reaction score
- 0
- Points
- 0
I would like to have a formula that recognizes a portion of the digits in Column A and produce a letter output if it meets the criteria. For example, if Col A has 358 in the number series then output is B, if Col A has 357 then output is C and so forth and so on. I have 17 output letters (A-Q). I have tons of data I need to apply this too. If have researched so many formulas. I am a novice when it comes to complex formulas so any help would be greatly appreciated. Thanks! Brenda
col A | Col B | Col C | Col d | Col E |
916 - 35806 35806 | AL7414 | 2499938 | 7/4/14 | $7.26 |
3246 - 35758 35758 | AL7414 | 2499966 | 7/4/14 | $6.50 |
1038 - 36830 36830 | AL7414 | 2500165 | 7/4/14 | $0.82 |
586 - 35976 35976 | AL7414 | 2500170 | 7/4/14 | $3.15 |