need help updating new prices

[JTS03]

I'm trying to pull pricing from a separate workbook. Not all part numbers are included in the new pricing, just the updated ones. Closest I've gotten is the formula below but I don't want a blank when false, I want the old but still current price to remain.


=IF(ISNA(VLOOKUP($E39,'[CINX-Search-Export__2019-03-06_02-46-52.xls]Grizzlist'!$A$8:$C$73,2,0)),"",VLOOKUP(E39,'[CINX-Search-Export__2019-03-06_02-46-52.xls]Grizzlist'!$A$8:$C$73,2,0))


Any help would be great.

 

[wrightyrx7]

I'm trying to pull pricing from a separate workbook. Not all part numbers are included in the new pricing, just the updated ones. Closest I've gotten is the formula below but I don't want a blank when false, I want the old but still current price to remain.


=IF(ISNA(VLOOKUP($E39,'[CINX-Search-Export__2019-03-06_02-46-52.xls]Grizzlist'!$A$8:$C$73,2,0)),"",VLOOKUP(E39,'[CINX-Search-Export__2019-03-06_02-46-52.xls]Grizzlist'!$A$8:$C$73,2,0))


Any help would be great.

Your overwriting the old value with a formula there isnt really a way to store the value that was in the cell before you put the formula in. The only way you could do this is by using VBA.

Or, put your formula in the column next to the old price. If it returns a value you know it needs uupdating.

 

[JTS03]

Thanks.