Can't pull data from website
I am trying to use the importhtml function to pull the data from a table that is posted on this website (https://moneypuck.com/stats.htm). The only table that I'm able to pull is the drop down portion at the top and that is when I use the following command. Using table 1 leads to a blank cell.
=IMPORTHTML("https://moneypuck.com/stats.htm","table","2")
I am trying to get the info from the screenshot below and would like it to update if possible. I don't care about TOI minimum if that is a problem. I was unable to do so as a list either
Screenshot of Table I want to copy
I also was wondering if any of you knew how to check a different sheet in the same book for the name of one cell and return the value for a cell that borders it. Shown below I have one sheet with this info. I want to pull the data from sheet 2 of the GP cell and Total Cell to the right of his name in sheet two.
Thanks yall!
Posted Dec 6, 2023, 8:51 PM UTC