gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 657
- Office Version
- 2019
- Platform
- Windows
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.
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.