Google Sheets importHTML help with indirect

AustSportingPix

New Member
Joined
Oct 5, 2020
Messages
44
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
  3. Mobile
Looking for ways to speed up my workflow and I found Google sheets "importHTML".
I've got it working with the website where I get most of my data from, but as the data gets added each day, there's a new webpage for this data.
The URL doesn't change much, its just part after the "Key=" (2021Nov06%2CVIC%2CFlemington)

=IMPORTHTML("Racing Australia | Horse Racing Results","table","3")

I've got a couple of drop down lists with all the data I need. These are cells M4 to M8
(M4: 2021
M5: Nov
M6: 06
M7: Vic
M8: Flemington)

The biggest problem I can see is the equals in the string.

Is there a way to do it?

I've shared the file

 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Is this what you're attempting to do? May or may not work in sheets, you shared your file as read only so I couldn't test it on there.
Book1
M
42021
5Nov
66
7Vic
8Flemington
9
10Racing Australia | Horse Racing Results
Sheet1
Cell Formulas
RangeFormula
M10M10=HYPERLINK("https://www.racingaustralia.horse/FreeFields/Acceptances.aspx?Key="&M4&M5&TEXT(M6,"00")&"%2C"&M7&"$2C"&M8,"Racing Australia | Horse Racing Results")
 
Upvote 0

Forum statistics

Threads
1,223,375
Messages
6,171,707
Members
452,418
Latest member
kennettz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top