Have an array formula which works fine in creating a list of matches from a table.
I'd like to include "partial" matches as well. Spreadhseet attached.
Want to include; in the results section beginning in cell B10, the "ww", and "bb" in the list because in the source data table, they also contain the value of "12".
I've tried adding "*"& etc to the A10 lookup value but it seems to hose the formula and it returns nothing.
TIA for any ideas.
Pete
Bookmarks