BeExcellant
New Member
- Joined
- Jun 17, 2020
- Messages
- 7
- Office Version
- 2013
- Platform
- Windows
I'm having one of those days where I'm experiencing a complete brain block... If a cell equals a product in a range, then the output should be the abbreviated code in the range in the adjacent column.
So, IF C3 equals one of the product names in A3:100, then the output will be the corresponding code in B3:100.
Example: IF C3(let's call it New York City) is found in A50, the output would be NYC, which is found in B50.
I hope this makes sense
Thanks!
So, IF C3 equals one of the product names in A3:100, then the output will be the corresponding code in B3:100.
Example: IF C3(let's call it New York City) is found in A50, the output would be NYC, which is found in B50.
I hope this makes sense
Thanks!