Match and move Cell?

[dyno]

Hi There,

Just joined and was looking to get some help. I am trying to integrate my website and store prices to the same price.

So far i have got to this.

i have 3 colums,

1. Barcode - Online 2. Barcode - Instore 3. Instore price

Basically what i want is a formula that would search the barcodes and if they are matching then add the price which is column c next to them.

Is that possible?

 

[Nalani]

Welcome to the Board

See if this works for you:

I am assuming you are trying to insert the Instore price next to a matching Onlin BC.

Excel Workbook
	A	B	C	D
1	BC Online	Match	BC Instore	Instore Price
2	037000125860	$1.25	09063634	$1.50
3	03435418	$5.64	037000125860	$1.25
4	09063634	$1.50	050505725809	$3.00
5	087547102107	$4.18	087547102107	$4.18
6	050505725809	$3.00	03435418	$5.64
Sheet1

Formula in B2 copied down:

=INDEX($A$2:$D$6,MATCH(A2,$C$2:$C$6,0),4)

 

[dyno]

That has worked thank you very much