Hello,

I have been searching around for a solution for this for a while. Seems that several People have the same issue only i cannot get any of the solutions given to other People to work in my case.

I simply want to do a VLOOKUP in several separate tables (3 to be excact). By Reading many other post they all come up With the solution to use the INDEX-MATCH instead.

I´ve tried this countless of times, but no matter what I do I´m still stuck With the excact same problem.

Using VLOOKUP I can manage fine to Reference to ONE singel table, that´s no problem. And when trying to use the INDEX-MATCH I can also get it to work as long as I only Reference to ONE singel table. In other Words, both Methods give me the same non satisfactory result.

I´m positiv that my coding would be the problem so I would really appreciate if anyone could solve the lookup in the following file that does not work.

Multiple tables problem.xlsm
Thanks in advance