The easiest way to use lookup functions is by clicking the functions button and filling in the prompts. You can also type the formula if you prefer.
How to use Xlookup - Excel by Ashley
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.