Name in different ways captured

[DHayes]

Good Day,
I am hoping there is someone that can help with a formula. The problem is the data is not captured constantly. So i have a name that gets captured in 3 different ways I need to find the value of this person for a specific month. Please if there is formula that I can use would be appreciated.

Sheet 1
A	B	C
Name	Sales	Month
John James Smith (John)	20	Oct-18
John James Smith	23	Nov-18
Smith John James	30	Dec-18
Sheet 2
	Oct-19	Nov-19	Dec-19
John James Smith

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

 

[Legacy 436357]

Why is this name captured differently? Excel cannot read your mind sorry. There may be other people with similar first, middle, or last names in different combinations.

I suggest you assign an ID number to that person and use that ID in your formulas.

I hope that helps,
XJ