I am trying to find a formula that will
1> read names from a tab
2> filter the data tab from that list using a wildcard (since names are in cell with other text)
3>Once found write the results of that row into a Results tab.
I have attached a simple example of the spreadsheet.
any help would be greatly appreciated.