Please help solve a combined IF formula

I have a list of variating addresses with one specific company name (calling it ABC Company). Code has been created to group these addresses by specific site names but new variations of the addresses are identified every day.
My current formula is xlookup(address, in address normalization table, return site name, if not in table label as shipper)
Is there a way to compound this so that it reads the above but if the shipper company name is ABC Company it identifies it as such and if not then ID it as shipper?

I have tried wrapping the xlookup with if and ifs but cannot seem to figure out how to make the argument work.