could you post an example of what you'd like to achieve?

I've several doubts about your target...

eg.

when someone enters the state, it will autopopulate the store

if there are several stores within the state, what is/are the criteria which store should be autopopulated?

does it really have to be autopopulated, or you just need to restrict list of possible stores by the state selected?

when someone enters the state, it will autopopulate the store, top and least sold item

are the top & least bound to the store or to the state?

how do you store sold items? do you save each and every sold item somewhere (list?) and expect the form ("vlookup") makes an aggregate per state/store/item or do you already have stored top & least aggregates at requested granularity level?

so having to link each store to a state and then link each items sold to each store will take forever

I'd assume you should already have a structure that links sold items to store and/or state. could you post a sample how does your current setup looks like?

I was able to figure it out. I used quick edit and was able to copy and paste both the original and the lookup column.

so is your problem resolved?

it did sound to me like your issue was the amount of data you were going to have build, but without those relationships in place it wouldn't work. Glad you found quick edit to build your data easily.

yes. thank you