If statements in VBA to look at multiple criteria without a nested formula

Hi,

I would like to write in VBA a list to advise IF contains this then return this for a number of outcomes. I have seen in the past this used to look for postcodes and then using the formula bar you can reference the code to check a cell rather than nesting IF statements.

Basically I want to check if cell contains APP then return APP, Else IF cell contains CARD then return CARD etc etc.

In excel I'd then just input

=(subname(CELL))

Thanks