## VLOOKUP
This function allows you to look up a value in a table and return a corresponding value from another column. It is useful for finding information from large data sets or matching data across different sources.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports VLOOKUP function | Supports VLOOKUP function |
| Can only look up values from left to right | Can look up values from left to right or right to left using the optional parameter `is_sorted` |

## SUMIFS
This function allows you to sum the values in a range that meet multiple criteria. It is useful for calculating totals based on specific conditions or filtering data.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports SUMIFS function | Supports SUMIFS function |
| Can handle up to 127 criteria | Can handle up to 30 criteria |

## COUNTIFS
This function allows you to count the number of cells in a range that meet multiple criteria. It is similar to SUMIFS but returns a count instead of a sum.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports COUNTIFS function | Supports COUNTIFS function |
| Can handle up to 127 criteria | Can handle up to 30 criteria |

## IFERROR
This function allows you to return a custom value or message if an error occurs in a formula. It is useful for handling errors gracefully and avoiding unwanted results.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports IFERROR function | Supports IFERROR function |
| Can also use IFNA function to handle #N/A errors specifically | Can also use IFNA function to handle #N/A errors specifically |

## INDEX and MATCH
These functions allow you to look up a value in a table by matching a row and column index. They are often used together as an alternative to VLOOKUP, especially when the lookup value is not in the first column of the table.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports INDEX and MATCH functions | Supports INDEX and MATCH functions |
| Can use wildcards (*) and (?) in MATCH function for partial matches | Cannot use wildcards in MATCH function for partial matches |

## XLOOKUP
This function allows you to look up a value in a range and return a corresponding value from another range. It is similar to VLOOKUP but more flexible and powerful, as it can look up values in any direction, handle arrays, and return multiple values.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports XLOOKUP function (only available for Office 365 subscribers) | Does not support XLOOKUP function |

## ARRAYFORMULA
This function allows you to apply a formula to an entire range of cells without entering it in each cell. It is useful for performing calculations on arrays or creating dynamic ranges.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Does not support ARRAYFORMULA function (but can use Ctrl+Shift+Enter to enter array formulas) | Supports ARRAYFORMULA function |

## UNIQUE
This function allows you to return a list of unique values from a range or array. It is useful for removing duplicates or finding distinct items.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports UNIQUE function (only available for Office 365 subscribers) | Supports UNIQUE function |

## SORT
This function allows you to sort a range or array by one or more columns. It is useful for organizing data or creating custom rankings.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports SORT function (only available for Office 365 subscribers) | Supports SORT function |

## FILTER
This function allows you to filter a range or array by one or more conditions. It is useful for extracting data that meets certain criteria or creating subsets of data.

| Microsoft Excel | Google Sheets |
| --- | --- |
| Supports FILTER function (only available for Office 365 subscribers) | Supports FILTER function |

I hope this helps you understand some of the differences and similarities between the functions in Microsoft Excel and Google Sheets.
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence