Hi hope you can help in a spreadsheet i use for my account managers one of the columns has the following formula
=IF(F6="",HYPERLINK("http://www.streetmap.co.uk/streetmap.dll?postcode2map?"&AK6&"","View Map"),HYPERLINK("http://www.streetmap.co.uk/streetmap.dll?postcode2map?"&F6&"","View Map"))

where f6 is a post code . If no postcode in F6 it looks at AK6 for a postcode of the nearest train station identified

This works fine but my account managers prefer google maps to streetmap can any one provide the formula to achieve this

thank you