To do Alt + M O on Mac in Excel, download and install Accelerator Keys, then press Option, followed by M, O.
Command: Lookup & Reference Functions Menu
This is how to do Alt + M O on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.
Alt + M O opens the Lookup & Reference functions dropdown menu in Excel’s Formulas tab. This menu contains essential data retrieval functions including VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, INDIRECT, and other functions for finding and referencing data across worksheets.