Help w/IF function that puts a value in another cell
Hi team - I have a sheet that has an column called ID that has specific alphanumeric entries:
I need an IF CONTAIN formula (maybe?) that looks to the first letter in the ID column and returns this value in a different column called Project:
- IF A then Project A
- IF B then Project B
- IF C then Project C
- IF D then Project D
- and so on...........
I got 1 piece working as a test:
=IF(CONTAINS("B", ID:ID), "Project B")
But don't know how to string the other options together.
Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!