Data validation list that depends on partially matched data?

That's close but I was aiming to only have 1 drop down, in the "location name". The values in the drop down would change with what the user has typed in the adjacent cell under "location #".