LOOKUP’s default behavior makes it useful for solving certain problems in Excel.

OR returns TRUEif any condition is TRUE.

If all conditions are FALSE, the OR function returns FALSE.

Excel formula: Highlight row and column intersection exact match

AND returns TRUEonly if all the conditions are met.

If any conditions are not met, the AND function returns FALSE.

Excel formula: Highlight duplicate rows

Excel formula: Highlight entire rows

Excel formula: Highlight rows that contain

Excel LOOKUP function

Excel OR function

Excel AND function

Article image

Article image

Article image

Article image

Article image