Hi,
I have a problem which i have no idea how to solve, and found no threads on the forum concerning it.
I have a workbook with two worksheets, one contains data input by engineers, the other contains the official descriptions of light bulbs.
On the engineers sheet, they often make mistakes when entering descriptions of bulbs. For example, the official list may state that it is a 28w 4pin. The engineer might but it as 28W 4P. Which creates havok because it cannot look up the according prices as its not recognised.
Is there a way to find similar descriptions to the list and replace them?
Any help much appreciated,
Tim
Bookmarks