There's some big ranges there... but perhaps:

=IFERROR(VLOOKUP(UPCLookup!A2,'0723'!$B$2:$Y$63014,23,FALSE),IFERROR(VLOOKUP(ProductMaster!B2:S149824,18,false),””))