IF and MID and ELSE

[smcelv]

Could someone please help me to add multiple functions in a search string?

=IF(MID(B18,2,8)="01330701","11-13 hours","") is giving me the desired result for that one formula.

I need to check B18 for 5 different number sequences which would return the same, "11-13 hours" result if met.
For example =IF(MID(B18,2,8)="01732401","11-13 hours","") Would give me the desired "11-13 hours" too.

Thank you in advance for any help you can supply.

Sam

 

[Gerald Higgins]

Try this for two of them, and if you get this working, you can adapt it for five

=if(or(MID(B18,2,8)="01330701",MID(B18,2,8)="01732401"),"11-13 hours","")

A better approach might be something like

=if(isna(vlookup(mid(b18,2,8),c1:c5,1,false)),"","11-13 hours")

where c1:c5 contains the 5 codes you want to compare against.

 

[Scott T]

You can use OR

=IF(OR(MID(B18,2,8)="01330701",MID(B18,2,8)="01732401",next sequences goes here,.. ),"11-13 hours","")

 

[tyija1995]

Another option, lets say you have placed the codes in to cells a1:a5

Then:
=IF(COUNTIF(a1:a5,MID(b1,2,8))=1,"11-13 hours","")

Where b1 is the first cell to check

 

[smcelv]

Thank you Gerald

Much appreciated.

Done what you suggested and just added to your formula.
Working fine now.

Again, many thanks.

 

[Gerald Higgins]

Hth, tftf