A cell should return a value by reading a string name

[VishwaRAFA]

Dear All,

Please find below problem description,

if A1 cell a contains "BFH" string, it should return last 20 characters of A1 in cell D1
if cell A1 contains BFH string , Cell E1 should return first 12 strings of B3
If cell A1 contains BFH string, Cell E1 should return value of B4

Kindly suggest me the solution

Regards

Vishwa

[oeldere]

d1=iferror(search("BFH",A1,1)>0,right(A1,10),""))

The other questions (cell E1) is the same logic.

[VishwaRAFA]

Hello Oeledere,

Thank you for the formula, but I am getting error msg "too many arguments entered", after correcting it to iferror(search("BFH",A1,1)>0,right(A1,10))), it I reading the value wherever BFH is not there, if BFH present it is showing "TRUE"

Kindly lemme know is there any other method to solve this

[oeldere]

I did not notice you still use the excel 2003 version.

=if(iserror(search("BFH",A3,1)),"",right(A3,2))

[Khalidngo]

Hi Vishwa,

Or you can try this in D1:

=IF(COUNTIF(A1,"*BFH*"),RIGHT(A1,10),"")

Blessing

[Khalidngo]

d1=iferror(search("BFH",A1,1)>0,right(A1,10),""))

Hi oeldere,

I think you have missed the IF:
=IFERROR(IF(SEARCH("BFH",A1,1),RIGHT(A1,10)),"")

Blessing