rajesh2022
New Member
I am trying to compare cells with another column. I need partial match, I tried vlookup but it gives exact match only.
Here is scenrio, in cell I have value as "Commercial and Operation Manager", this value I need to compare with another column range, where I have cell value Operation (Partial Match), if match found, need to pull next column value.
So I will not get exact match always, some times partial match.
Attaching sample file for reference.
Here is scenrio, in cell I have value as "Commercial and Operation Manager", this value I need to compare with another column range, where I have cell value Operation (Partial Match), if match found, need to pull next column value.
So I will not get exact match always, some times partial match.
Attaching sample file for reference.
Attachments

13.8 KB Views: 5