MMyslenski
New Member
- Joined
- Apr 11, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi all,
Someone showed me this at my last job but I can't remember it. I am trying to write a formula that will look at the fourth digit of a number, and then based on what that number is, return a specific text. As an example, if I had the following cells
A B
1 1234 Bill
2 4321 Bob
3 6789 Sally
4 9786 Sam
the formula would say "If in cell X, the fourth digit is 4, type Bill, if its 1, type Bob, if its 9, type Sally, if its 6, type Sam" I hope that makes sense. I searched this site for the last 15 minutes and found similar formulas but not exactly what I am looking for.
Someone showed me this at my last job but I can't remember it. I am trying to write a formula that will look at the fourth digit of a number, and then based on what that number is, return a specific text. As an example, if I had the following cells
A B
1 1234 Bill
2 4321 Bob
3 6789 Sally
4 9786 Sam
the formula would say "If in cell X, the fourth digit is 4, type Bill, if its 1, type Bob, if its 9, type Sally, if its 6, type Sam" I hope that makes sense. I searched this site for the last 15 minutes and found similar formulas but not exactly what I am looking for.