Using the attached table data I run into the following issues:
1) I would like to extract data from the Standings tab into the Data tab using the abbreviaiton of names. I do not seem to be able to come up with a solution. The data to be extracted is the data located in the STRK (i.e. K column) into the corresponding team in the Data tab)
2) In the Standings tab, the "L10" label is supposed to read as ##-## but instead it either reads as date format like J6 or a five number sequence and I do not know where that number sequence comes from.
The original data for the "J" Column reads ##-## (i.e. "7-3").
P.S. I have not formatted the Standings tab as a table to give flexibility in problem solving. Format as you see fit, as long as it works as intended.
P.P.S. The original data is copied from the following web page,
If there is a way for Excel to update directly from this website in the same format it would be desired but not required.