After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
Need help replicating Richard Baxter's Keyword research
-
A few years ago(maybe it was last year?), Richard Baxter gave a live demo of some fancy keyword research techniques at MozCon. I've been using those methods for a while,but can't figure out how to pull all the keywords from a list that match keywords in a table. I know it's either a VLookup or an Array formula. Does anyone here remember that presentation? Able to help out?
Thanks in advance,
Chris
-
He has an awesome post here on Moz about matching keywords using an array formula - the info is here - http://moz.com/blog/keyword-research-using-categories
formula template is =IF(SUM(NOT(ISERROR(FIND('Keyword Types'!$A$2:$A$7,$A2)))*1)>0,P$1,"Non-"&LOWER(P$1))
then hold shift, CTRL, and enter - refer to the post for what to do - I love this method and find it very helpful for lots of stuff.
Good luck,
Mark
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Explore more categories
-
Chat with the community about the Moz tools.
-
Discuss the SEO process with fellow marketers
-
Discuss industry events, jobs, and news!
-
Chat about tactics outside of SEO
-
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
-
