Wilcard Vlookup or Index Match

[Mattman121]

I have created a fantasy golf sheet to track scores of players and assign points automatically. However, I am running into a problem when during the tournament the player starts on the back nine which adds a "*" next to his name. This changes day to day. The first day he may have an "*" but the second day he may not.

Index(Sheet1!$H$2:$H$150,match(B11&"*",Sheet1!$D$2:$D$150,)))

I started using this because it will pull the name if it has the "*" in it but then if the name changes the next day and does not it fails to pull the data. The data automatically updates from a website. Is there any way to search an either or so it searches for both the name with an "*" and without?

Thank you in advance!

Matt

 

[Chrisdontm]

Try this Matt;

=IF(B11="","",IFERROR(IF(MATCH(B11&"*",Sheet1!$D$2:$D$150,0),INDEX(Sheet1!$H$2:$H$150,MATCH(B11&"*",Sheet1!$D$2:$D$150,0))),INDEX(Sheet1!$H$2:$H$150,MATCH(B11,Sheet1!$D$2:$D$150,0))))

 

[Mattman121]

Works perfectly, thanks!