Address Details (Post Code/Longitude/Latitude

Morning all,

This is a longshot and not sure if it is even possible but I am trying to populate the post code along with longitude & latitude for an address. I have attached a test spreadsheet and ideally need formulas for the columns [Post Code] [Longitude] [Latitude] to lookup on the internet and populate the information. The main spreadsheet contains about 100,000 entries so doing this 1-by-1 is an impossibility.

Fingers crossed there is a genius that can help!