Hello,
Hello,
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 ???
Regards
Thanks a lot for your valuable reply
Please find the attached excel file, i am getting error for A3, A4, A8, A9 where data match is available.
Please guide
https://www.sendspace.com/file/ah00x5
Regards