If sheet 1 has company names (and duplicates of those names)
company A company B company A company A
the other sheet has all those company names and their URLs (no duplicates)
company A - url company B - url company C - url
Is there a formula to allow Sheet 1 to look at sheet 2, and if there is a match to return the corresponding url next to the name?