Return the Value Based on Two Columns

[chinraj]

Hi,
I need a vba code to return the value if two column's values are in sheet1 matching into sheet2,

Let us assume that, I have two sheets in a workbook(Sheet1 and Sheet2), In Sheet1, Col A and B are there some value and same like in Sheet2(Additionally Result in Col C)
I want to return the value in Col C of Sheet1(till A2 to last used rows) from Sheet2(Col C), if the first two column's values are matching with both sheets.

I have attached a sample workbook. Any help would be greatly appreciated!

Thanks,
Chinraj

[AB33]

In sheet1 c2 and drag it down

Please Login or Register  to view this content.

[chinraj]

Thank you very much for the formula. It works perfectly.
Then, How to convert this into VBA script. Bcoz, I need to put this till last used rows of Col A.
Any idea Please!!

Thanks,
Chinraj

[AB33]

The formula works the same way as a code, but if you want a code:

Please Login or Register  to view this content.

[chinraj]

Thank you again for the code. Its working fine for very small number of rows.
I have few hundreds of rows in my sheet. When I apply this code to run, it is taking too long time to get result.
What would be the cause. How can I overcome this issue. Or any loop statement code are there in VBA?

Please advise. Thanks,

Regards,
Chinraj

[AB33]

Faster code.

Please Login or Register  to view this content.

[chinraj]

Regret to inconvenience caused.
Still I'm getting the same issue(Slow operation). I think the issue is not in above code. I put your reply(#2) formula in C2 and fill down to C1000 manually, even that time, I was getting the same issue.

Please help me. Thank you again.

- Chinraj -

[AB33]

Built-in formulas are faster than a code. The code itself does not loop, it should also be faster, so I do not know what kind of data you are working on.
If there are data in adjacent column, The auto fill should auto, not manually
Are your data imported from outside source? Are they imported from a website, or accounting application, such as SAP or Oracle? If so, the data are the issue?

[chinraj]

Built-in formulas are faster than a code. The code itself does not loop, it should also be faster, so I do not know what kind of data you are working on.

I got resolved after some modification of code. Thank you very much for your all prompt responses and its much appreciated.