You can enable macros in Excel using the Trust Center or enable a specific macro from the security warning at the top of a spreadsheet.
You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.