=TOOLS.A1

Formula builder

Pick what you're trying to do, fill in your cells, and get the exact formula — updated live as you type.

Value to find

Range to search in

Range to return from

Show this if not found

Fields marked * are required.

Your formula

=XLOOKUP(D2, A:A, B:B, "Not found")

Tip: values in quotes are inserted as text — edit the formula directly if you need a number or cell reference instead.

Learn more: XLOOKUP(), VLOOKUP()

Sources we reference — not partners

26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.

Official documentation

Educators and channels

Course platforms

AI & data tools