Populate table using row and column headings to index cells

I'm pretty new to Excel as far as going this in depth, but I was wondering if anyone had input as to whether a concept I have is possible...

I have a "Data Table" that has customers going down and product numbers going across. I made a cover page that allows a user to select a costumer and a product number and display whatever information is in the grid on the "Data Table". I did this using Index and Match functions.

Right now, there is no data inside this "Data Table". I was hoping that there is someway to "reverese" my Index and Match functions to allow me to enter data into this grid instead of retrieve it.


I am posting in the VBA thread because I explored using a form powered through VBA but the coding to put the data where I needed seemed too intense for me.


Just for a reference, my "Data Table" is about 2,000 lines across and 3,000 lines down, so any way to make entering this data easier is invited!!!

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. Your title "Is This Even Possible???" doesn't tell us anything about your question. I have updated it for you this time because you are a new member. --6StringJazzer