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
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…
When Teal brought me in, their bottom-of-funnel content was barely moving the needle. Blog posts…
Clicks are down, and if you’re working in SEO right now, you’re probably stuck trying…