You can do a VLOOKUP in Excel for Mac by using the VLOOKUP function in your formulas. The VLOOKUP function is located in the Lookup & Reference category in the Formula tab in the Ribbon.