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
Thanks
Luke