Do the same thing for each subsequent “URL # links to A?” rows.
The reference to column B “Links to Target URL” isn’t going to change, but the reference to the related URL column will. For example:
In F2 (“URL 2 links to A?”) you will be looking for the E2 URL within the list of URLs in B2:
=IF(ISNUMBER(SEARCH(E2, B2)), "Exists", "Not Found")
Copy this formula down column F. In H2 you will be looking for the G2 URL within the list of URLs in B2:
=IF(ISNUMBER(SEARCH(G2, B2)), "Exists", "Not Found")
Copy this formula down column H. Repeat this process for each of the “URL # links to A?” columns.
This made it easy to spot where the internal links were missing.
I double-checked a few entries manually to ensure everything was accurate. Now, I have a complete list that shows each target URL in column A, the top 5 related URLs, and whether those URLs are linking back to the target URL.
My final spreadsheet looked like this, with “Exists” or “Not Found” indicating whether each related URL was linking back to the target URL:
If you liked How I Found Internal Linking Opportunities With Vector Embeddings by Everett Sizemore Then you'll love Miami SEO Expert
Here’s what stuck with me:Start simple. A rough prototype beats a perfect idea.Be specific when…
Virtually every SEO tool is powered by scraped search results. In order to get more…
How to build a brand-led content strategy that drives demand outside searchYou’ll learn to move…
Five years after this video was created, the idea that machine learning might be “far…
I’ve spent the past year fielding the same panicked question from clients repeatedly: “Why is traffic…
Claim and Verify All Listings with a Domain EmailWe all know how to claim and verify…