similar to Vlookup but multiple options

[shre0047]

I have a table in one tab similar to the example below (table x):

a12	Europe	4/4/2016	John
b34	Europe	4/3/2016	Peter
a12	north America	4/5/2016	Lucy
a12	Asia	4/1/2016	Wade

In another tab, I have a table like so (table y):

Source	Object	Name
Europe	a12
Asia	a12
Europe	b34

In table y, I want a macro to provide the names based on comparing the object and the source. I tried to do a vlookup based on object only, but that only provides the first name listed in table x, John, for both Europe and Asia rows in table y

[AlKey]

Try this

Enter formula in H2 and copy down

Please Login or Register  to view this content.

v	A	B	C	D	E	F	G	H
1	Object	Source	Date	Name		Source	Object	Name
2	a12	Europe	4/4/2016	John		Europe	a12	John
3	b34	Europe	4/3/2016	Peter		Asia	a12	Wade
4	a12	north America	4/5/2016	Lucy		Europe	b34	Peter
5	a12	Asia	4/1/2016	Wade

[Kevin#]

Not sure you need VBA
You can achieve this with formulas
Insert an extra column to left of each table and in that column concatenate:
-In table 1, cell in columnA followed by cell in columnB
-In table 2, cell in columnB followed by cell in columnA
This gives you the values you want to match
Then use vLookup as normal

see attached workbook