How to do OR operator in FIND formular

[pete212]

Hello,

I have the following formular: =FIND("*",H12)

This searches for the first * character in cell H12, and returns the character position of that *. And it works great!

However, I have a condition where sometimes H12 doesnt contain any * characters, and has a hash (#) character instead. Is there anyway to do a formular that says find the character position of the first * OR # within cell H12?

Thanks for any help you can give.

 

[Scott T]

Try

=IFERROR(FIND("*",H12),IFERROR(FIND("#",H12),""))

 

[Marcílio_Lobão]

pete212, Good afternoon.

Try to use:

=IFERROR(FIND("*",H12),IFERROR(FIND("#",H12),""))

Is that what you want?

I hope it helps.

 

[Scott Huish]

Assuming it's one or the other:

=LOOKUP(9.99999999E+307,FIND({"*","#"},H12))

 

[Marcílio_Lobão]

Assuming it's one or the other:

=LOOKUP(9.99999999E+307,FIND({"*","#"},H12))

Scott, Good afternoon.

Very good approach!

Have a nice day.

 

[pete212]

Thank you so much! That worked perfectly!