Copy data from column K to column B if Column C and column I match

Hello!

I need help.

So I want to update prices. To overwrite old prices with new.

In column C I have all barcodes and in column I I have barcodes that needs to be changed in column B.

So what is the formula or better macro to copy(overwrite) prices from column (K) to column (B) only if (C) and (I) match. And (C) and (I) do match but in column (C) there are around 3000 entries and in column (I) around 70. So on every line in column (C) have to check all in column (I) and then copy from (K) to column (B)

Price(B) BarCode (C)
26,00 kn 4024406252301
140,00 kn 3856005446063
155,00 kn 3856005446070
135,00 kn 3856005446056
135,00 kn 3856005446049
150,00 kn 3856005446032
150,00 kn 3856005446025

Barcode (I) Price(K)
3831020116825 67,20 kn
3831020113879 96,00 kn
3856005419784 121,20 kn
3856005419791 221,40 kn
3856005419807 442,80 kn
3856005419890 169,20 kn
3856005419906 258,00 kn
3856005419913 453,60 kn
3856005419944 169,20 kn

This is all in one sheet.

Thank you!!!

Hi goog. Try:

Please Login or Register  to view this content.

Thank you! This seams to be working very well!

My pleasure.