Forum Discussion
Solved
Excel WEBSERVICE #Value Error
In the WEBSERVICE("http://api.openweathermap.org/data/2.5/weather?lat=34.82&lon=-87.99&APPID=key") ; I want to use lat and lon values from cells like H4,etc. How can I do it?
Assuming your URL correctly works in browser, you may generate URL string as
=WEBSERVICE("http://api.openweathermap.org/data/2.5/weather?lat=" & TEXT(H4,"##.##") & "&lon=" & TEXT(H5,"##.##") & "&APPID=key")
Assuming your URL correctly works in browser, you may generate URL string as
=WEBSERVICE("http://api.openweathermap.org/data/2.5/weather?lat=" & TEXT(H4,"##.##") & "&lon=" & TEXT(H5,"##.##") & "&APPID=key")