the same in both your “Current Positions”

[rochon.a1.119]

You can get ranking data from several keyword tools. I use SEMrush. Downloading all the keywords you currently rank for in the top 100 from SEMrush is a fairly quick process. When you do this, you'll likely find that you have rankings for some terms that aren't on your list, so add a "New Sheet" to your Excel document (call it "Current Rankings") and paste in all the terms for which you have ranking data.



image.png
Next, add a “Current Position” column to your main Keyword Plan document. Using the VLOOKUP formula , it’s simple to get the ranking data that matches the term for each row where the keyword is sheet and your “Keyword Plan” sheet.

- Compare that value to all the values ​​in the cell range A1 through B49995 on the "Current Rankings" sheet (all the cells with data on the sheet you pasted all the rankings into).

image.png

- When there is a match in the two values, returns the contents of the cell in the second column (the "2" in the formula) of the row where the data matches (in this case, that data is northeast mobile database the data in column B or the current position).

- FALSE tells Excel that the data must match exactly. TRUE would be for a partial match, but in this case, you want the keywords to match each other exactly.

- Make sure to put the $ in the formula to prevent the data from changing as you copy, paste, or drag the formula to other cells in the Current Position column. For example, in cell B3 in the Keyword Plan tab example above, put the formula =VLOOKUP(A3,'Current Position'!$A$1:$B$49995, 2, FALSE) and not the formula =VLOOKUP(A3,'Current Position'!A2:B49996, 2, FALSE). The lookup row needs to change from A2 to A3, and you don't want the range to lookup to change from 'Current Position'!A1:B49995 to 'Current Position'A2:B49996.