Excel DropDown Searchable and No Blanks or Gaps

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=mIpDe82YWv8

Get this spreadsheet here: https://www.smarthelping.com/2016/10/... • This excel template involves a whole bunch of cool formula tricks in combination with data validation in order to allow the user to have a searchable drop-down menu based on a given range as well as a conditional drop-down menu that populates based on a given value in order to return the list of stores/what have you that contain/have the given value entered into the first drop-down cell. • In simple terms, if you had 1 item at store x and y but not store a/b/c, the drop-down would only populate with store x and y based on those stores being the only ones that contain the item. If you had another item that was only at store a/b/c/ than only those would show in the drop-down. This is dynamic and contains no spaces/gaps between the values in the actual drop-down menu.

#############################

New on site