Thank you all in advance for your help on this subject. I am using the following formula.
=IF(ISNA(VLOOKUP(B19,Statistics!$B$4:$I$616,8,FALSE)),0,(VLOOKUP(B19,Statistics!$B$4:$I$616,8,FALSE)))
Right now it works correctly, with one exception.
I need to copy and paste things from the internet for the Statistics page. The trouble is that there are usually 0-2 extra spaces at the beginning of the name I am trying to get excel to look up. (This is for a hockey pool stats tracking sheet.)
For example. On one of the rosters there is D. Roy and he scored in Buffalo's game last night. But when I copy the yahoo website information it puts in 2 spaces at the front of his name and sometimes afterwards as well (**D. Roy* - the * represents spaces). Even though the name is spelt the same, the formula can't see it as the same. This seems like a small problem but I can't figure it out. Any help would be greatly appreciated.
If you would like to see the spreadsheet, let me know and i will email you one.
Thank you
=IF(ISNA(VLOOKUP(B19,Statistics!$B$4:$I$616,8,FALSE)),0,(VLOOKUP(B19,Statistics!$B$4:$I$616,8,FALSE)))
Right now it works correctly, with one exception.
I need to copy and paste things from the internet for the Statistics page. The trouble is that there are usually 0-2 extra spaces at the beginning of the name I am trying to get excel to look up. (This is for a hockey pool stats tracking sheet.)
For example. On one of the rosters there is D. Roy and he scored in Buffalo's game last night. But when I copy the yahoo website information it puts in 2 spaces at the front of his name and sometimes afterwards as well (**D. Roy* - the * represents spaces). Even though the name is spelt the same, the formula can't see it as the same. This seems like a small problem but I can't figure it out. Any help would be greatly appreciated.
If you would like to see the spreadsheet, let me know and i will email you one.
Thank you