The VLOOKUP function is a very useful excel technique to do a vertical “v” lookup in an array table and output the results next to the table you want. In Keyword research it can be used to look up a keyword rankings list and output result in a keywords search data table. The technique is explained by Richard Baxter at SEO gadget which also provides the enclosed example excel worksheet.

vlookup-example