Back to Functions
XO.LCONTACT
Lookup a property of a contact by contact name. Returns email, phone, account number, or status.
Syntax
=XO.LCONTACT(org_id, contact_name, property)
Parameters
| Parameter | Required | Description |
|---|---|---|
| org_id | Yes | Organization ID from XO.ORG() |
| contact_name | Yes | Contact name (must match exactly) |
| property | Yes | Property to return (0-3) |
Property Options
| Code | Property | Description |
|---|---|---|
| 0 | Email address | |
| 1 | phone | Phone number |
| 2 | accountNumber | Account number/code |
| 3 | status | Contact status (ACTIVE, ARCHIVED) |
Examples
Get contact email:
=XO.LCONTACT(A2, "ABC Corp", 0)Get phone number:
=XO.LCONTACT($A$2, "John Smith", 1)