HubSpot’s Erik Devaney has shared a guide to use VLOOKUP in Excel 2013 and 2016 for calculating the revenue. Devaney says, “Below, you’ll see a five-step guide to performing this VLOOKUP example, followed by a video tutorial for using VLOOKUP to organize a list of blog posts. How Does VLOOKUP Work? The secret to how VLOOKUP works? Unique identifiers. A unique identifier is a piece of information that both of your data sources share, and — as its name implies — it is unique (i.e. the identifier is only associated with one record in your database). Unique identifiers... [...]