How to copy a column when two others match

[NotSoLameBen]

Hello,

I have three columns of numeric data, I'll refer to them as A, B, and C. Here is what I want to do.

I want excel to search for whenever a value in row x of column "A" matches a value in row y of column "B", then I want it to copy the data from row y in column "C" to row x in column "D".

I hope that is clear. I am pretty sure I will need a macro to do this, but I have very little experience with excel, so I am unsure. Any ideas on how to do this? Thanks!

[DonkeyOte]

I am pretty sure I will need a macro to do this...

Quite possibly but we would need a far more accurate outline of the issue to be able to determine that one way or another.

For ex it may be you can use:

Dx: =INDEX(C:C,MATCH(Ax,B:B,0))

A sample file (with expected results) will surely help us visualise exactly what it is you want to do.

[StephenR]

A formula is probably possible, but using code perhaps like this?

Please Login or Register  to view this content.

[NotSoLameBen]

Hopefully this will get the idea across.

[DonkeyOte]

Extending earlier formula based example:

G1: =IF(COUNTIF(B:B,F1),INDEX(C:C,MATCH(A1,B:B,0)),"")
copied down

[NotSoLameBen]

DonkeyOte,

That did it. Thank you very much for your help.