Problem with reference to multiple arrays in INDEX/MATCH combo

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

see the attached file

Pl see attached file.

So as I'm not a VBA user (I know, I should be) I tend to use VLOOKUP, or INDEX and MATCH for such problems.

Anyway, having admitted my limitations find attached an example of doing what you want without VBA and Combo boxes.

VLOOKUP - Multiple tables.xlsx

Cheers,

Originally Posted by nflsales

see the attached file

Thank you for effort in finding a solution. I see that Your Excel file does work but when I through that same formula into the real Excel file, only changing the Cell referenced to and array, I cannot get it to work

Another thing is also this: After this one ROW where the machinemodel is choosen there are about 20 more ROWS under that one for the configuration of the model. This means that there has to be some set of rules that say IF choosen model is for example Kyocera FS-2026MFP+ then all the 20 ROWS under only show the possible items that og along With that machinemodel. This way the machine cannot be configured wrong.

In other Words, even if I was to get Your formula to work, is there a way to add rules/events to the procedure as well?

This was the reason I started out using ComboBoxes. The only problem With them is that I have to program each and every singel thing for all 20 CB´s as they are all on seperate ROW´s.

Originally Posted by Ursul

So as I'm not a VBA user (I know, I should be) I tend to use VLOOKUP, or INDEX and MATCH for such problems.

Anyway, having admitted my limitations find attached an example of doing what you want without VBA and Combo boxes.

Attachment 260387

Cheers,

Hi Ursul,

Thanks for Your effort as well Please see my other postreply to nflsales for my NeXT steps. Your solution would also give me the same Challenge. I Guess I should have mentioned my NeXT step in my orginal post. I see now that this changes the possible solutions here....

Hello JBeaucaire.
I knew this but I realized that my thread should have been in a different section and I am unable to delete the first thread once posted. This is why this happened.
I would appreciate if you could tell me how to delete wrongly posted threads. Thanks