Matching the data across column and rows using VBA

[chauhananirudh2012]

[COLOR=#BBC0C4 !important][COLOR=#6A737C !important]

[/COLOR]
[/COLOR]
I have two sheets:
Sheet 1 consist of :

Sheet 2 consist of :

And the output should show in M column in Sheet1. I am attaching the sample output here :

So,what I have here is ID in Sheet 1, for eg : ID 'US' has Abhay,Carl and Dev and in Sheet3, I have names in column and ID in Rows. What i want is my Sample output column should populate using macro based on matched values from Sheet3
I am using below logic but something is going wrong :
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">For i = 2 To 10
j = i + 1
If ThisWorkbook.Sheets("Input").Range("N" & i) = ThisWorkbook.Sheets("Sheet3").Range("A" & i) And ThisWorkbook.Sheets("Input").Range("K" & i) = ThisWorkbook.Sheets("Sheet3").Range("B1") Then
ThisWorkbook.Sheets("Input").Range("O" & i) = ThisWorkbook.Sheets("Sheet3").Range("B" & j)
End If
Next i</code>

I know this can be done with vlookup, but How can Vlookup satisfies two criterias of matching? Moreover, I have 2000+ data.

 

[Peter_SSs]

2000 rows of data isn't that much for Excel, so I would still consider using a formula approach. Here is one.

Excel Workbook
	A	B	C
1		US	NA
2	Name
3	Abhay	Data 1	Data 7
4	Carl	Data 2	Data 8
5	Dev	Data 3	Data 9
6	Narg	Data 4	Data 10
7	Sita	Data 5	Data 11
8	Geeta	Data 6	Data 12
Sheet2

Excel Workbook
	K	L	M
1	ID	Name	Output
2	US	Abhay	Data 1
3		carl	Data 2
4		Dev	Data 3
5	NA	Carl	Data 8
6		Narg	Data 10
7		Sita	Data 11
8		Geeta	Data 12
Sheet1

BTW, for future reference, you will get many more potential helpers if you post any sample data in small copyable screen shots in your post. That way people can copy your sample data to a worksheet to test (most helpers don’t like having to type out test data). My signature block below has a link for several ways to do that. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.