Could using one of the lookup functions help? (lookup the part number and
return the cost).


"Stephen" wrote:

Hi, I am trying to compare two values (part numbers) and copy a value from
one column to another replacing the current value (cost). Not all values on
the sheet will change.