Advanced SEO Audit Techniques: Excel

Click Data > Filter and uncheck the box next to “Blanks.” Then, select “Create a filter” in the Data tab. Click Data > Filter. Use The “VLOOKUP” FunctionThe VLOOKUP function allows you to search for a value in one data set and return a corresponding value from another data set. If you have a “sale page” in one data set and a “landing page” on the other, it won’t work. To make the table: Data > Pivot Table to open a new sheet with a blank pivot table.