There is a much easier way in mapquest, googlemaps, etc. Just deconstruct the url and use the hyperlink expression in any cell like any other formula. This method allows you to fill down just like you would with any formula.
For example with lat and long:
Code:
=HYPERLINK("http://www.google.com/maps?f=q&hl=en&q=" & A2 & ",+" & B2,"Google Map")
Or get creative an only show the hyperlink where there is a valid lat and long:
Code:
=IF(ISNUMBER(I3),IF(ISNUMBER(J3),HYPERLINK("http://www.google.com/maps?f=q&hl=en&q=" & I3 & ",+" & J3,"Google Map"),"enter longitude"),IF(ISNUMBER(J3),"enter latitude","enter lat and long"))
I am sure this would work with addresses too, you just have to deconstruct the URL of a query.
Previous
Index
Next
Flat
Re: open googleEarth from excel...
Edit
Reply
Quote
