See the uploaded workbook.
Note that there are some errors, with the following reasons:
1-Some player names you want to lookup don't exist on the lookup range.
2-Some of the column headers you want to lookup either have different names in the lookup range, or don't exist there.
I have marked those that don't exist with red, and those that are named differently with yellow.
The only drawback is you have to enter the dates manually, which I think won't be a problem with so few cells that are adjoiningly located.
Yet, if you desperately need a macro to enter the date, just ask![]()
Bookmarks