Return one value if condition is true, another if false — e.g., pass/fail check.
Returns TRUE if all conditions are TRUE.
Searches for a value in the first column and returns a value in the same row.
Joins multiple text strings into one.