suppose I have data in two column of a sheet, and in first column I have mentioned various location and in 2nd column I have put name of shop. Now I want in new sheet in formula in such a way that if I put list of all location in a cell by data validation and choose any location then all shop corresponding to particular location should be come in next column.Screen Shot 2017-01-07 at 8.12.25 AM.pngScreen Shot 2017-01-07 at 8.12.30 AM.png