All
Search
Images
Videos
Shorts
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
XLOOKUP with Boolean OR logic
To configure XLOOKUP with Boolean OR logic, use a lookup value of 1 with a logical expression based on addition. In the example shown, the formula in G5 is: =XLOOKUP(1,(data[Color]="red") (data[Color]="pink"),data) where data is the name of the Excel Table in the range B5:E14. Note: see below for an equivalent formula based on INDEX and MATCH.
May 16, 2024
Related Products
Boolean Data Type Example
Boolean Example in Coding
Boolean Function Example
#Boolean Expression Tutorial
Boolean Algebra
calcworkshop.com
Feb 1, 2021
Boolean Algebra Examples (Part 2)
YouTube
Apr 12, 2015
Top videos
8:00
Data Types in Programming: Numbers, Strings and Others
Study.com
Paul Zandbergen
240K views
Dec 19, 2013
Booleans Python | Boolean Data Type Explained in Hindi | Python Tutorial for Beginners | Booleans
YouTube
CognitiaX AI
30 views
3 weeks ago
5:46
Venn Diagram
YouTube
Neso Academy
228.8K views
Oct 29, 2015
Boolean Algebra Simplified
4:04
What are Raina and Jadeja?
byjus.com
33.7K views
Aug 8, 2015
8:22
Boolean Algebra | Concepts, Rules & Examples
Study.com
22K views
Sep 11, 2024
Simplify Boolean Equation AB+(AC)!+AB!C(AB+C) (Part 2)
YouTube
Ranjan Barman
18.4K views
Dec 30, 2016
8:00
Data Types in Programming: Numbers, Strings and Others
240K views
Dec 19, 2013
Study.com
Paul Zandbergen
Booleans Python | Boolean Data Type Explained in Hindi | Python T
…
30 views
3 weeks ago
YouTube
CognitiaX AI
5:46
Venn Diagram
228.8K views
Oct 29, 2015
YouTube
Neso Academy
5:53
Boolean Algebra Examples (Part 2)
743.9K views
Apr 12, 2015
YouTube
Neso Academy
7:10
Boolean Model
10.2K views
Oct 11, 2019
YouTube
TutorPlus
7:48
Boolean Algebra Examples (Part 1)
981.5K views
Apr 7, 2015
YouTube
Neso Academy
1:26
Boolean Data Type Example
600 views
Nov 18, 2014
YouTube
Trisect
7:28
Understanding Logic Gates
1.2M views
Jun 15, 2020
YouTube
Spanning Tree
4:53
The boolean Data Type in Java
124.2K views
Dec 23, 2019
YouTube
Neso Academy
6:19
Boolean function example (C++ programming tutorial)
193.1K views
Aug 26, 2015
YouTube
Engineer4Free
10:03
Example Problems Boolean Expression Simplification
1.4M views
Feb 12, 2018
YouTube
ENGRTUTOR
5:21
Boolean Searching Basics
198K views
Jul 7, 2011
YouTube
KateTheLibrarian
18:11
Introduction to Boolean Algebra (Part 1)
2M views
Apr 7, 2015
YouTube
Neso Academy
11:14
Fundamentals of Boolean Algebra
951.1K views
Jan 26, 2018
YouTube
TutorialsPoint
9:49
Python Booleans (Comparison & Logical Operators) #6
66.5K views
Sep 4, 2020
YouTube
Programiz
3:03
Primitive Data Types (Java Tutorial)
13.1K views
Nov 26, 2017
YouTube
Bill Barnum
13:53
Boolean Java Tutorial #15
254.1K views
Feb 21, 2019
YouTube
Alex Lee
23:43
Quine-McCluskey Minimization Technique (Tabular Method)
2.1M views
Oct 14, 2015
YouTube
Neso Academy
9:47
Implement boolean function using decoder
240.3K views
Nov 4, 2016
YouTube
amith nayak
6:31
Searching Effectively Boolean Operators
52.2K views
Aug 3, 2018
YouTube
OSLIS Elementary Videos
10:36
21 - The Boolean Data Type in Java
21.6K views
Mar 16, 2018
YouTube
Math and Science
8:34
Implementation of Boolean Function using Multiplexers
2M views
Jan 7, 2015
YouTube
Neso Academy
14:35
#10 Python Tutorial for Beginners | Data Types in Python
1.7M views
Jul 5, 2018
YouTube
Telusko
10:36
PubMed: Basics of Searching
215.6K views
Jun 25, 2020
YouTube
Welch Medical Library
4:55
Boolean Algebra Basics and Example Problem
369.5K views
Nov 4, 2017
YouTube
Tangerine Code
13:50
Boolean Expression Represented as a Truth Table Example 1
131.2K views
Mar 8, 2017
YouTube
Maths and Stats
6:29
Java Tutorial - Basic data types and variables
796.8K views
Feb 1, 2021
YouTube
LinkedIn Learning
3:05
Online Research: Tips for Effective Search Strategies
595.3K views
Jan 20, 2016
YouTube
Sarah Clark
26:56
Quine McCluskey Method Explained: Optimizing Boolean Ex
…
152K views
Apr 29, 2020
YouTube
Engineering Funda
See more videos
More like this
Feedback