Excel - VLOOKUP word within a sentance
Budget: ₹600 – ₹1,500 INR
Hello, I am trying to find a VBA MACRO which will find a keyword within a sentence line and if found then it will show the result mentioned against keyword.
For example: In A2 "Pack of 10 Ball pen Blue" is mentioned and i want to lookup the value "Pen" and return the result "Pens & Refills".
And please note lookup value and return value list is another sheet of same workbook. and it can go upto 100 rows and macro must be non-case sensitive.
I will be paying maximum 600-800/- INR for this task.
For example: In A2 "Pack of 10 Ball pen Blue" is mentioned and i want to lookup the value "Pen" and return the result "Pens & Refills".
And please note lookup value and return value list is another sheet of same workbook. and it can go upto 100 rows and macro must be non-case sensitive.
I will be paying maximum 600-800/- INR for this task.