Hi Folks
I've taken web data from sky sports for the premiership
I want to extract the news alerts as the page updates
I've tried H lookup to find Bournemouth News and return the information in the next cell but I get N/A
=HLOOKUP(Bournemouth!S53,B49:B68,2,0)
Looking forward to your answer thanks
DATA
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col span="5"></colgroup>
I've taken web data from sky sports for the premiership
I want to extract the news alerts as the page updates
I've tried H lookup to find Bournemouth News and return the information in the next cell but I get N/A
=HLOOKUP(Bournemouth!S53,B49:B68,2,0)
Looking forward to your answer thanks
DATA
| Emerson Hyndman | - | - | - | - | - | |||||
| Ryan Fraser | - | - | - | - | - | |||||
| Sam Surridge | - | - | - | - | - | |||||
| Matthew Worthington | - | - | - | - | - | |||||
| Connor Mahoney | - | - | - | - | - | |||||
| Attacking Midfielder | Pld | G | YC | RC | FF | |||||
| Marc Pugh | - | - | - | - | - | |||||
| Jordon Ibe | - | - | - | - | - | |||||
| Striker | Pld | G | YC | RC | FF | |||||
| Benik Afobe | - | - | - | - | - | |||||
| Callum Wilson | - | - | - | - | - | |||||
| Joshua King | - | - | - | - | - | |||||
| Lys Mousset | - | - | - | - | - | |||||
| Lewis Grabban | - | - | - | - | - | |||||
| Jermain Defoe | - | - | - | - | - | |||||
| Bournemouth News | ||||||||||
| I couldn't wait, Ake tells Conte | ||||||||||
| Nathan Ake has defended his move to Bournemouth after Antonio Conte insisted Chelsea's young players are too impatient. | ||||||||||
| 01/08/17 8:20am | ||||||||||
| Pre-season friendlies recap | ||||||||||
| Live updates from Saturday’s pre-season friendlies, with Newcastle, West Ham, Stoke, Watford, Brighton and Leicester all in action. | ||||||||||
| 29/07/17 12:35pm | ||||||||||
| Transfer Centre LIVE! | ||||||||||
| The latest news and rumours, with updates on the futures of Kylian Mbappe, Neymar, Philippe Coutinho and Nemanja Matic. | ||||||||||
| 01/08/17 7:00am | ||||||||||
| Bournemouth news archive | ||||||||||
<!-- // provide an anchor for the no javascript fallback menu --> Home | ||||||||||
| Sports |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col span="5"></colgroup>
