Hi all, I came across a previous thread here that partly answered exactly what I was looking for, they wanted to know how to use if to return certain criteria.

I have codes in a column that start with 1 of 3 letters, if they start with "e" I want say, "eggs" returned, if they start with I, I want say, "India" returned and if they start with V I want say "Voice" returned, is there a way I can extend this formula to have all 3 options covered?
so, what I learned from the previous thread and worked perfectly was that this would work for me for the first condition -

=if(left(a1,1)="E","eggs","") then how do I extend this to cover the other two possibilities?

Thanks so much in advance, glad I came across this thread & forum!