Return Multiple Data Sets

[luke1438]

I am trying to create a multiple lookup where by someone would type in a word or set of words and then hit a button. A search would then be performed on another Sheet within the same Workbook returning any (all if there are 30, than all 30) cells in column A that had that word or words along with the information in corresponding column B. I have become fairly good with formulas and know of no way to get a formula to return anything more than the first match. I think this needs to be done with a macro but my macro knowledge is limited to recording a macro and then maybe doing minor changes. I have no idea where to even start on something like this. Any help or advice would be greatly appreciated.

Thanks
Luke

 

[Fazza]

hello

One option for you might be a parameterised query. No formulas & no code.

Google will find examples. This is close to your description,
http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/

HTH