Looking for a correspondence in VBA

**seoer** · 08-12-2011, 10:21 AM

Hi Guys,

I need to look for a correspondence between a value formed by two or more column, and in case I found a result I need to copy the result from the adjacent cell to the destination cell, which in my case is the cell where excel was originally.

I was wondering which is the best way to do this.

Can you provide me an example too?

Thanks
Andrea

**TMS** · 08-12-2011, 11:37 AM

Can you provide me an example too?

It would actually be better if you posted an example of the data/columns you want to work with and a number of scenarios and outcomes.

To be honest, as it stands, I'm not sure I understand the question.

Regards

**seoer** · 08-13-2011, 05:23 PM

Hey TMShucks,

thanks for the answer, but it looks I can't really upload any files here yet. Perhaps I still need some permission is going to be applied after a certain number of posts.

I'll try to make it simpel here.

Col A Col B Col C
abc def 10
hhh ffff 20
abc def ??

Ok, now assume I im 3C, and I run my query ... what I what is to find the previous correspondance of abc def which are distributed on two separate columns. If a correspondance exists, what I what is copy the value from 1C in this case into 3C from which my macro has been called.

Simple as that.

Does it make sense?

Thanks
Andrea