From the course: Excel for Marketers (2023)

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Joining multiple data sets together

Joining multiple data sets together - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Joining multiple data sets together

“

- [Instructor] Quite often, you'll find yourself using Excel to join multiple data sets together. For example, if you have conversions in one report and then you have ad spend and another report, you need to be able to match that data together to report on cost per conversion. Let's walk through how to do that. So, the real workhorse of Excel for marketers is VLOOKUP. This is probably the most used formula I have. And the way it works is this, you type in VLOOKUP and then you want the lookup value. That's the key that you're looking up. In this case, it's campaign name, you have campaign one and then we want to tell it where to look up from. So we're just going to select this area here. I'm going to press F4. That's going to lock that in place or you could actually just put the dollar signs in front of it. What that does is when we drag that down, it's not going to look anywhere else. It's just going to stick with that…

Contents