19 functions
Logical
- ANDYAND checks several conditions and returns TRUE only if all of them are met; if one fails, it returns FALSE. In Spanish Excel it is called Y. Syntax: =AND(logical1, [logical2], ...). It is almost always used inside IF.
- IFSIIF checks a condition and returns one value if it is met and another if it is not. In Spanish Excel it is called SI. Syntax: =IF(logical_test, value_if_true, value_if_false).
- IFERRORSI.ERRORIFERROR returns the result of a formula and, if that formula returns an error, the value you choose. In Spanish Excel it is called SI.ERROR. Syntax: =IFERROR(value, value_if_error).
- IFSSI.CONJUNTOIFS checks several conditions in order and returns the value of the first one that is met, with no nested IFs. In Spanish Excel it is called SI.CONJUNTO. Syntax: =IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...).
- OROOR checks several conditions and returns TRUE if at least one is met; it returns FALSE only if all of them fail. In Spanish Excel it is called O. Syntax: =OR(logical1, [logical2], ...). It is almost always used inside IF.
Lookup
- INDEX and MATCHINDICE / COINCIDIRMATCH gives the position of a value and INDEX returns the value at that position. Together they look up in any direction. In Spanish Excel they are called INDICE and COINCIDIR. Syntax: =INDEX(array, MATCH(lookup_value, lookup_array, 0)).
- INDEXINDICEINDEX returns the value at a given row and column of a range. In Spanish Excel it is called INDICE. Syntax: =INDEX(array, row_num, [column_num]).
- MATCHCOINCIDIRMATCH returns the position of a value inside a row or column. In Spanish Excel it is called COINCIDIR. Syntax: =MATCH(lookup_value, lookup_array, [match_type]).
- VLOOKUPBUSCARVVLOOKUP looks up a value in the first column of a table and returns a value from the same row. In Spanish Excel it is called BUSCARV. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
- XLOOKUPBUSCARXXLOOKUP looks up a value in a column or row and returns the value in the same position of another, to the left or to the right. In Spanish Excel it is called BUSCARX. Syntax: =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found]).