UK Postcode link to Google Maps

[The Jackal]

Hi,

I am trying to create a map from a postcode in cell C13 by using this formula in I13.

=HYPERLINK("Google Maps"&C13,"MAP")

This opens google maps up but the search in Google Maps that is performed is "C13". I want this to be the postcode, not the cell.

Any ideas???

 

[Toadstool]

Hi The Jackal,

Google is often changing and I believe that method stopped working some time ago. Google normally wants you to register with them for an API key but this API option seems to work....for now.

TheJackal.xlsx
	C	D	E
12
13	NE9 7TY		MAP
14	GL1 2EH		MAP
15
Sheet1

Cell Formulas
Range	Formula
E13:E14	E13	=HYPERLINK("https://www.google.com/maps/search/?api=1&query="&C13,"MAP")

 

[The Jackal]

Hi The Jackal,

Google is often changing and I believe that method stopped working some time ago. Google normally wants you to register with them for an API key but this API option seems to work....for now.

TheJackal.xlsx
	C	D	E
12
13	NE9 7TY		MAP
14	GL1 2EH		MAP
15
Sheet1

Cell Formulas
Range	Formula
E13:E14	E13	=HYPERLINK("https://www.google.com/maps/search/?api=1&query="&C13,"MAP")

Works perfectly, Thanks

 

[The Jackal]

Well,

It worked at home when using my chromebook (sheets) but now i have put it into excel its not working again.

Very strange.

 

[Toadstool]

Still working OK for me:

=HYPERLINK("https://www.google.com/maps/search/?api=1&query="&C13,"MAP")