Vlookup with wildcard to return highest value?On sheet1 - column A I have a list of URLs. In column B I have a quality rating.
On sheet2 - column A I have domains. In column B I have the highest "quality rating". It goes from "best", "good", "bad"
On sheet2 - A2, if I type "forbes.com" I need B2 to return the "Best". If I type "businessinsider.com" in A3, I need B3 to return "Good".