Forum Discussion
Solved
How to identify letter combinations in a cell value
Hi Needing some help with identifying what type of grant I have on worksheet using a formula. Each grant has its own project code, the format or letters dictate what category of award it its. For...
= IFS(
LEFT([@CODE],1)="D", "GEN GRANT",
LEFT([@CODE],2)="RS", "INTERNAL GRANT",
TRUE, "KEY GRANT" )Same idea but uses Table referencing and the IFS function.