My goal is to essentially create a VLookup function. The best I can find is to create a new list for each column and link each one back to the first. In the example below, when someone enters the state, it will autopopulate the store, top and least sold item. So I have to create 4 lists. State, then State linked to Store etc. The issue is there are hundreds of stores, so having to link each store to a state and then link each items sold to each store will take forever. 1st question. Is this the best way to accomplish what I am trying to do? If so, is there a way to just upload all the stores instead of linking each one?