Build from a task
Formula Recipe Builder
Choose a common spreadsheet job and generate a starting formula you can adapt to your own sheet.
=XLOOKUP(A2,Products!A:A,Products!D:D,"Not found")
Always confirm ranges, data types and locale-specific separators before using a generated formula in important work.