copying data from cells

Originally Posted by spondy29

I have a list of cells with parts and costs
then a new list with new costs
how do i get the new costs into the old list
Part numbers the same cost different
Thanks
Spondy

Hi,

the simple answer is to use VLookup into a new column, with a blank setting for missing 'new' prices, thus something like

=If(IsError(Vlookup(A1,newprices,2,False)),"",Vlookup(A1,newprices,2,False))

followed by Copy (the column) and Paste Special = Values (tick Skip Blanks) over the Old Prices, then remove the VLookup column,

however,

if you have formula etc using the prices be aware that changing the prices will also change all of those formula values.

hth
---