Good Afternoon!
I have two spreadsheets, one with a persons name as follows
Smith, John H
Joyce, James R
And another missing the last initial like so:
Smith, John
Joyce, James
If there is a match I have some data from the second table I put into the first. Now I have accomplished maybe 90% of this with the following formula:
=IFERROR(VLOOKUP(Table2[[#All],[Physician Name]],Table1,5,FALSE),"Not Found")
The only thing I need help with now is that function only works if I remove the initial from my first sheet which I can't do due to reporting requirements. Any ideas how I can get this function to simply ignore the initial if there is one? (Table 2 with the Physician name is the one that has the troublesome letters)
Thank you for all your help!
I have two spreadsheets, one with a persons name as follows
Smith, John H
Joyce, James R
And another missing the last initial like so:
Smith, John
Joyce, James
If there is a match I have some data from the second table I put into the first. Now I have accomplished maybe 90% of this with the following formula:
=IFERROR(VLOOKUP(Table2[[#All],[Physician Name]],Table1,5,FALSE),"Not Found")
The only thing I need help with now is that function only works if I remove the initial from my first sheet which I can't do due to reporting requirements. Any ideas how I can get this function to simply ignore the initial if there is one? (Table 2 with the Physician name is the one that has the troublesome letters)
Thank you for all your help!