I am searching for a excel vlookup function, but vlookup table is different. There are two excel tables.
table 1
one 11 12 13
two 21 22 23 24
six 61 62
table 2
11 one
13 one
22 two
61 six
So the problem is that I have Table 1 as in input and in Table 2 I have numbers 11,13,22,61 and I have to get from the Table 1 words one, two, six. So this is like Vlookup table but inverse. There are multiple keys in one line and wanted values is the the first column. Do you have some idea how to get these values
