Lookup Rows from a Data Extension - Ampscript

Lookup Rows from a Data Extension - Ampscript.html

%%[
SET @query = "Query text"
SET @resultSet = LookupRows("Data Extension name","Field name for matching condition", @query)
IF RowCount(@resultSet) > 0 THEN
	SET @row = row(@resultSet,1) 
	SET @Field1 = Field(@row,"FieldName1") 
	SET @Field2 = Field(@row,"FieldName2") 
	SET @Field3 = Field(@row,"FieldName3") 	
ENDIF
]%%

<!-- Print the result values -->
%%=v(@Field1)=%% <br>
%%=v(@Field2)=%% <br>
%%=v(@Field3)=%% <br>