excelback.com
=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.

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()