compare values and replace

[Stephen]

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.

[Peter Ellis]

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.