LOOKUP(2, 1/....formula using OR in criteria

[gtd526]

Hello,
I have 2 formulas that I'm using and are working.
I would like to use OR (or something similar) to search for 2 different values.

--------------------------------------------------------------------
IFERROR(LOOKUP(2, 1/((COUNTIF($H$173:$H173, '[NFL.xlsm]Weekly Picks'!$H$4:$H$35)=0)*( '[NFL.xlsm]Weekly Picks'!$H$4:$H$35<>"")*('[NFL.xlsm]Weekly Picks'!$F$4:$F$35<>"*")), '[NFL.xlsm]Weekly Picks'!$H$4:$H$35),"")

As criteria its using <>"", <>"*"
Is there a way to search for <>"", and (<>"*" OR ="B"). This way if either are present, then the formula works.
--------------------------------------------------------------------
IFERROR(LOOKUP(2, 1/((COUNTIF($H$179:$H179,'[NFL.xlsm]Weekly Picks'!$H$4:$H$35)=0)*('[NFL.xlsm]Weekly Picks'!$H$4:$H$35<>"")*('[NFL.xlsm]Weekly Picks'!$F$4:$F$35="*")),'[NFL.xlsm]Weekly Picks'!$H$4:$H$35),"")

As criteria its using <>"", ="*"
Is there a way to search for <>"", and (="*" OR ="B")
--------------------------------------------------------------------

Thank you.

 

[earthworm]

To Use Or Criteria use "+" sign

 

[RoryA]

Is there a way to search for <>"", and (<>"*" OR ="B").

That doesn't really make sense: "B" is not "*" so would already meet the <>"*" criterion.

 

[gtd526]

To Use Or Criteria use "+" sign

Thank you for the reply.