Looking for a way to automatically fill a table using data from another table, when providing a certain input.

[Struck]

I am creating a very large dataset (50-60 thousand unique entries), and I am currently in the process of writing a formula that will fill certain sections automatically, given certain inputs.

The autofill would be dependent on 2 variables (V1 and V2), such that I would want the formula to identify the value of V1, and then given this value of, identify the value of V2, and then from this information, it would be able to assign the value of subsequent variable V3 automatically. An example of this be trying to autofill residents in a city, given their address, such that V1 is the name of their street, and V2 is their house number. When V1 is given, and then a subsequent V2 is given, it is then possible to know which residents should be assigned to the house, but BOTH variable must be known before this is possible.

I am aware that an IF function could be used in this case, but as there are 200 possible V1 values and 100 possible V2 values, this would be a huge and clunky solution. I was wondering if there was a simpler, faster way to do this.

If it helps at all, I have a table of V1, V2 and V3 values already saved to a spreadsheet. Could this be used in some way?

Thank you very much

 

[Rijnsent]

Hi Struck,
could you post a dropbox/g-drive/etc link to your file, that would help solving your question ?
Thanks,
Koen