ExcelBanter - compare values and replace

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - compare values and replace (https://www.excelbanter.com/new-users-excel/71839-compare-values-replace.html)

Stephen

compare values and replace

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

compare values and replace

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.

All times are GMT +1. The time now is 10:24 PM.