Which statement about the AMPscript Lookup function is true?

• A. It returns all rows that match a value without using an AND clause.
• B. It returns a specified field value from a data extension and can include multiple field/value pairs in an AND clause.
• C. It updates a data extension based on a given key.
• D. It concatenates the specified fields into a string.

Answer: (B)

AMPscript Lookup is used to fetch a single value from a data extension by specifying one or more search criteria. You tell it which data extension to look in, the field you want to return, and then provide pairs of field names and values that define the filter. Each pair adds to the filter with AND, so all conditions must be met. The function returns the value from the first row that matches all the given criteria. It does not pull multiple rows, nor does it update the data extension. If you need every matching row, you’d use LookupRows; for updates, UpdateData or UpsertData would be used. This aligns with the statement: it returns a specified field value from a data extension and can include multiple field/value pairs in an AND clause.