Insight | How to perform "VLOOKUP" in Insight
For more information and tips visit the Eloqua Insight Resource page.
Similar to VLOOKUP ( or IF statements) in excel, this formula allows you to look up and retrieve information based on a comparison of columns.
It’s a great formula to have in your pocket for data hygiene initiatives or simply to compare data for inconsistencies.
To demonstrate how to build this formula we’re going to compare first and last name contact fields to ensure they do not have the same data.
Formula: CASE WHEN "COLUMN1"= "COLUMN2"THEN 'V1' ELSE 'V2' END
V1= value you want to return if there is a
Tagged:
0