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
Bookmarks