Only replace certain cells while leaving others intact

[UAL225]

So this is a new problem I have come up against which I cannot figure out how to solve.

What I am trying to do is look up the various container numbers in the "Daily Report" from "Lookup sheet 1" and replace the values in "Daily" report with the values from "Lookup sheet 1." However, I do not want to use a vlookup or something so I wipe the other data.

For example:
CAIU7252705 only needs the Shipment Reference - SRN replaced in Daily report, however BEAU4778380 needs only the Material Code replaced and not the SRN. So how do I go about creating a formula or something that I can change / replace these various fields while keeping the rest of the data intact? Like for BEAU4778380 the SRN is correct, but the material code is not.

[izzy-analytics]

Other than with a VBA solution, I don't know how you can do this without replace existing values... unless you create a copy of the daily-report "All Shipments" tab. If you do that... on say an "All Shipments(2)" tab, then you could do something like this in cell B1 as an example:

Please Login or Register  to view this content.

In human speak, this is saying... lookup the container number on the lookup report.. if that returns a zero or an error, then use the original data, otherwise use the new data.