Excel Dog

  This tutorial demonstrates how to use the AND Function in Excel and Google Sheets to test if multiple criteria are all true. What is the AND Function? The AND Function checks whether all conditions are met. Returns TRUE or FALSE. AND can evaluate up to 255 expressions. How to Use the AND Function Use the Excel AND Function like this: = AND ( 1 = 1 , 2 = 2 ) Since both of these expressions are true, AND will return TRUE. However if you used the following: = AND ( 1 = 1 , 2 = 1 ) In this case AND would return FALSE. Although the first expression is true, the second isn’t. Note that numerical values alone are counted as TRUE, except zero, which is counted as FALSE. So this formula would return true: = AND ( 1 , 2 , 3 ) But this one would return FALSE: = AND ( 1 - 1 , 2 ) This is because 1-1 evaluates to 0, which AND interprets as FALSE. Compare Text Values Text comparisons with the AND Function are not case-sensitive. So the following formula returns...

  XLOOKUP Syntax The XLOOKUP Syntax is: XLOOKUP ( lookup_value , lookup_array , return_array , [match_mode] , [search_mode] ) Where: lookup_value – What to look for lookup_array – Where to look return_array – What to output [match_mode] – (OPTIONAL) Specify type of match to perform. Default is Exact Match (see table below for all options) [search_mode] – (OPTIONAL) Specify type and direction of search. Default is First-To-Last (see table below for all options) XLOOKUP Match_Mode 0 – Exact match will only find exact matches 1 (-1) – Will perform an exact match or find the next largest (smallest) item. 2 – Wildcard character match allows you to use ? or * wildcards for inexact matches. XLOOKUP Search_Mode 1 – Search top to bottom (or left to right for horizontal lookup) -1 – Search bottom to top (or right to left for horizontal lookup) 2 (-2) – Binary search on sorted data.  If you don’t know what a binary search is, you probably won’t ever need to perf...