Create your own Excel Search Pt. 4 - Select search items
Channel: Matt Paul
Date: 27/09/2011

Find me on Twitter here:  https://twitter.com/MattPaul25

Email me at xlsxgeek@gmail.com with TEMPLATE as the subject line and ill send you my search template. It has all of the searches and solves the issue of duplicate values. 

In this video: 
I show you how to select items in your search list and have a table to the right build based on the selections made. I know its not perfect so feel free to input your thoughts on better ways to do this. 

Two other ways to pull data with the match and the column letters which i did not go over, include the following:
You can place these in cell k8 if you have the workbook. Im working on a way to have the files easily available to you guys.

Far more complex:   
OFFSET(INDIRECT("Data!"&$J$8&$H10),,COLUMN(INDIRECT(K$8&1))-COLUMN(INDIRECT($J$8&1))

Far simpler:
 INDIRECT("Data!"&K$8&$H10)