Resolve MAC vendors by the row. =VERVE("macaddresslookup", A2) returns the manufacturer and formats for each address — Sheets or Excel.
It's one of 300+ live sources you reach with a single =VERVE()function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — these inputs, and the values they land in your sheet.
Fill =VERVE("macaddresslookup", A2) down your list of hosts or IPs and land the answer for each in its own row — no terminal, no scripts.
Add MAC Address Lookup's lookup beside an existing table to turn bare identifiers into readable, structured detail.
Combine the result with IF and conditional formatting to surface the rows that need attention.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("macaddresslookup", A2)Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("macaddresslookup", A2)Add a field name as the last argument to land just that value in the cell.
=VERVE("macaddresslookup", A2, "mac")=VERVE("macaddresslookup", A2, "isValid")=VERVE("macaddresslookup", A2, "vendor")=VERVE("macaddresslookup", A2, "oui")=VERVE("macaddresslookup", A2, "formats")Everything you need to wire it into a sheet.
