zipporapper
New Member
- Joined
- Feb 23, 2013
- Messages
- 12
Hi All kind excel experts out there. Need your expertise and guidance. I have a dilemma. I am trying to do a vlookup of values of Column B in Column A and return a text that says "False" in Column C, if values in Column B is not the same in Column A and empty if is the same.
The problem is Names in column B and in Column A are not exact matches due to Middle names or spacing after the comma or at times missing middle names.
My idea is i want excel to use just the Last name in column B and ignore the first name after the comma and use that last name as lookup value to lookup in Column A. Like Doe in B1 and Doe in Column A2 would be a TRUE but return as a blank in column C1. Also if there is a mismatch or there are names missing in column A when column B is used a lookup value, Column C will return the value as False or any other text that i wish. Is there anyway i could do that?
<tbody>
</tbody>
Appreciate your help experts! Cheers. Thanks!
The problem is Names in column B and in Column A are not exact matches due to Middle names or spacing after the comma or at times missing middle names.
My idea is i want excel to use just the Last name in column B and ignore the first name after the comma and use that last name as lookup value to lookup in Column A. Like Doe in B1 and Doe in Column A2 would be a TRUE but return as a blank in column C1. Also if there is a mismatch or there are names missing in column A when column B is used a lookup value, Column C will return the value as False or any other text that i wish. Is there anyway i could do that?
A | B | C | |
1 | Lee,Vice | Doe,John B | =vlookup(????? |
2 | Doe, John | Lee, Vice T | |
3 | Robertson, Sinclair D | Howard, Mary J | |
4 | Howard, Mary | Robertson,Sinclair | |
5 | Moses, Victor | Pires,Robert | FALSE |
<tbody>
</tbody>
Appreciate your help experts! Cheers. Thanks!