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
Bookmarks