Connect two table based on two criterias.

Dear Helpers,


I have following situation:

Table 1
(column)
(A) Order Number
(B) Operation Number
(C) Employee Number <- (My goal is to bring this column from Table 2 to Table 1 in the right order based on the Order and Operation Number)
et cetera (other important columns, which are not included in Table 2)

Table 2
(column)
(A) Order Number
(B) Operation Number
(C) Employee Number

Example

Table 1
Order Number/ Operation Number/ Employee Number/ (other important columns)
W1234/ 020/ (to be added)/

Table 2
Order Number/ Operation Number/ Employee Number/
W1234/ 020/ 334/


Goal:

In both table Order Number and Operation Number are equal, therefore Employee Number should be added in the right row in table 1.


I can not use vlookup, since vlookup is only working with one criteria. But I need to add the Employee Number based on two criterias.

Thank you very much for your help in advance.

BR

Hi erekose and welcome to the forum,

Use Index Match as shown in the attached instead. I've created a short sample of your problem.

Index Match two columns Lookup.xlsx

A common approach to this sort of problem is to create helper columns which concatenate the multiple columns which together are unique. With this then VLOOKUP or INDEX-MATCH will work.