I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some errors , but a partial match of data is being accepted. Which function can we use as I have tried Match & Vlookup it only searches for exact data. Is there any function for partial match of data available ???