Sorry this site requires JavaScript to be enabled in your browser. See the following guide on How to enable JavaScript in Internet Explorer, Netscape, Firefox and Safari. Alternatively you may be blocking JavaScript with an advert-related or developer plugin. Please check your browser plugins.

Sphinn Home » Vertical Search
Using VLOOKUP to match keyword volume and rankings data
Vertical Search News Source: http://seogadget.co.uk
Published: Nov 25, 2008 - 06:42 am
Story Found By: firebreatherseo 1174 Days ago
Category: Vertical Search
Ever needed to compare lists of keywords in different data tables and match corresponding values together? For example, matching keyword volume data to search engine rankings? Today Richard takes a look at a really simple but powerful query in Microsoft Excel called VLOOKUP which makes that possible.
 Comments4 Comments  

Comments

Avatar
from anthonyverre 1174 Days ago #
Votes: 0

I use VLOOKUP all the time.  It takes a couple of times to get the hang of, but it is such an incredible time saver.  This works especially well matching KW SERP Positions to estimated traffic or comparing a lot of disparate data on a single sheet to make informed decisions on KWs

Avatar
from anthonyverre 1173 Days ago #
Votes: 0

an easier way to do VLOOKUP is to the FX function in the formula bar. Then type vlookup in the search function.  It put all the necessary fields you’ll need to create the query.  Additionally, you will want to make the logical statement, "FALSE", that way the function does NOT find the closest match, but will find the exact, true match.

Avatar
from richardbaxterseo 1173 Days ago #
Votes: 0

Hi Anthony! Using a "0" is the same as typing "FALSE" and using a "1" is the same as typing "TRUE". Finding the closest match works fine in some situations with numbers but it’s obvious we don’t want to go that way in this scenario. You’re right about the formula bar, that’s an easy way to do simple queries and a good way to learn the syntax. That said, it blows when it comes to creating more complicated logic or nested IF statements.

Avatar
from willcritchlow 1173 Days ago #
Votes: 0

I prefer index() and match() to vlookup - find them easier to work with, but nonetheless, this is useful stuff. Good work.

Upcoming Conferences

Search Marketing ExpoSearch Engine Land produces SMX, the Search Marketing Expo conference series. SMX events deliver the most comprehensive educational and networking experiences - whether you're just starting in search marketing or you're a seasoned expert.


SMX Web Site » | SMX Difference » | SMX News »

Join us at an upcoming SMX event:

Latest News From Marketing Land
Upcoming Webcasts

Search Marketing Now Learn more about search marketing with our free online webcasts and webinars from our sister site, Search Marketing Now. Upcoming online events include:


Latest News From Search Engine Land