Hey, I'm trying to find something that can help me collaborate two excel colums into some meaningful data.
Only problem is that my name list is not exactly the same so is there a formula that searches partial matches?
eg. I know about the "MATCH" and "VLOOKUP" function but that only works if two cells are identical
so what I have is for example
Data set A:
Bill Gates = 1
Steve Jobs = 2
Michael Jackson = 3
Data set B:
Bill Gates MSFT = $100
Jobs, Steve = $200
Michael Jackson = $300
The match/vlookup function will only work for michael jackson? Is there a function which will allow me to find the examples of bill gates of steve jobs? I have a list of 350+ names and besides editing them by hand to make them the same (PAIN IN THE ASS) I don't know any other way.
Even something that can tell me its one of 3 possible matches (if there are conflicts) would help a lot)
thanks in advance.
Only problem is that my name list is not exactly the same so is there a formula that searches partial matches?
eg. I know about the "MATCH" and "VLOOKUP" function but that only works if two cells are identical
so what I have is for example
Data set A:
Bill Gates = 1
Steve Jobs = 2
Michael Jackson = 3
Data set B:
Bill Gates MSFT = $100
Jobs, Steve = $200
Michael Jackson = $300
The match/vlookup function will only work for michael jackson? Is there a function which will allow me to find the examples of bill gates of steve jobs? I have a list of 350+ names and besides editing them by hand to make them the same (PAIN IN THE ASS) I don't know any other way.
Even something that can tell me its one of 3 possible matches (if there are conflicts) would help a lot)
thanks in advance.