vlookup challenge with hyphen data placement

B

browland

Joined
May 26, 2012
Messages
3
Reaction score
0
I am trying to marry data from column A to Column B in a new Column C using the vlookup function, but am challenged with hyphens blocking everthing, but exact matches. My vlookup is =VLOOKUP($A2,B:B,1,0) the only matches that are working are exact like 001081190136-0013 in the below. Any Vlookup gurus know how to solve this?

Column A
00108-1197128
00108-1168197
001081190136-0013

Column B
00108460817-0017
001081168197-0013
001081190136-0013

Column C
N/A
N/A
001081190136-0013
 
Last edited:
This should return the correct value in Column C, but returns N/A. This is my challenge.

Column A
00108-1168197

Column B
001081168197-0013

Column C
N/A
 
Last edited:
This is a match and returns correct: 001081190136-0013

Column A
001081190136-0013

Column B
001081190136-0013

Column C
001081190136-0013
 
Last edited:
Back
Top