I have a cross-reference table in the tab "ProdDescPartialXRef" with column A as partial matches (i.e. "WARMER") and column B as corrected descriptions (i.e. LEG WARMER). My other tab is "All Prods" and contains a list of descriptions that need to be corrected in Column A. Column B of that tab has the following formula to access the xref table:
Right now it is only whole-word matching (because of the spaces on either side of the tab reference), but if I remove the spaces it breaks the formula. Right now the xref value "WARMER" only matches something like "LEG WARMER TOY" but I would also like it to match "LEGWARMERTOY".
I've attached my spreadsheet for your perusal. Any help would be appreciated. Thanks to NBVC for helping me get this far--and now, kind reader, would you help me make the final step?
Dan
Bookmarks