Using the condition of the 4th character in the cell to produce 1 of 4 possible outcomes

[Ruthie83]

Dear all,

I am looking at using module code to generate module type in a separate column.

For e.g., module code AR2101 has the 4th character 1, which corresponds to a core module. 4th character 2 would correspond to an elective module, 3 an enrichment module, 4 an extra credit module.

Would you be able to suggest which functions I should use?

Thanks

[Ruthie83]

This is what I tried but it didn't work!

=LOOKUP(MID(E2,4,1),"1","2","3","4", Core, Elective, Enrichment, Extra Credit)

[Tony Valko]

Try it like this:

=LOOKUP(MID(E2,4,1),{"1","2","3","4"},{"Core","Elective","Enrichment","Extra Credit"})

[Ruthie83]

Thanks! That worked brilliantly.

[Tony Valko]

We can save a couple of keystrokes with this version:

=LOOKUP(--MID(E2,4,1),{1,2,3,4},{"Core","Elective","Enrichment","Extra Credit"})

[Tony Valko]

You're welcome!