Ok I think I know the answer to this, but any suggestions would be huge.  I have a monster of a price list(2800 Sku's) for my company with multiple vendors.  about once a month at least one of the vendors will send through price corrections, but not neccessarily on every sku.  They will only indicate the ones that are changing and leave a "0" amount on the unchanged ones. Still easy to figure, but it does require that I copy/paste the old prices into a column, and then use that column in my formula to account for any prices that remain the same. I am thinking there has to be an easier way.  This is the formula I use. =IF(N2>0,VLOOKUP(A2,M:N,2,0),IF(N2=0,K2))  N2 is of course the new price and K2 is the copied old price. Is there a way of running this process without the need to copy and paste the old prices?  Let me know if I need to clarify,