I am working with an excel assignment with a spreadsheet that is out of order. I need a formula that searches through "Column A$"$ for the correct domain, and if it doesn't match what the company name says in$"$Column B$",$ then I need the correct domain entered it into "Column C$",$ but only if Column A shows it to exist. In other words, Column A is not in the same order as Column C$,$ but the domain should match the company name that is in Column B$,$ assuming it is found in Column A$.$ I hope this makes sense.

Column A $-$ Domains

Column B $-$ Company Name

Column C $-$ Assumed Domain

There are $1591$ rows to go through.