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
Bookmarks