if(find...help

[MartinL]

I'm trying to search a cell for either "(C)" or "(M)" and return "Express" or "Metro" else "Main"

so far this doesnt work

=IF(FIND("(C)",Table1[[#This Row],[Product]])>0,"Express",IF(FIND("(M)",Table1[[#This Row],[Product]])>0,"Metro","Main"))

Can anyone help

 

[Akashwani]

Hi Martin,

Is this it?....

=IFERROR(IF(FIND("M",Table1[[#This Row],[Product]])>0,"Metro"),IFERROR(IF(FIND("C",Table1[[#This Row],[Product]])>0,"Express"),"Main"))

One question. Are you always looking for a capital letter?
If not, use SEARCH instead of FIND.

Ak

 

[MartinL]

Hi AK

Thanks for that
Yes its always a caplital letter but it is also (M) or (C) dont worry I saw your deliberate mistake and put it back in.

Thanks

Martin

 

[Akashwani]

Hi Martin,

I'm pleased it worked for you.

deliberate mistake

Table Nomenclature!!!
I'm still trying to come to grips with that, that is why I "deliberately" missed off the (), that's my excuse any how.

{[(Ak)]}