Import Xml using XPATH

Hi guys & gals

Can anyone help me here with ImportXML functions?

In the example I will use a table containing items on Amazon.co.uk
In column A, I will be pasting the product URL
In column B, I would like the title of the product to be pulled from the page linked in column A (using ImportXML/FilterXML & Xpath, or a web query that I can use right through the column)
In column C, I would like the current price to be pulled from the page in the same manner as the title in column B.


I've had something like this work on Google spreadsheets, but I would prefer to use Excel to do the same tasks, the Xpath syntax that I get for the title & price are as follows:

Title: //*[@id="productTitle"]
Price: //*[@id="priceblock_ourprice"]


A B C
1 URL Title Price
2 http://www.amazon.co.uk/dp/B0094J1MBO
3 http://www.amazon.co.uk/dp/B0094J1MH8
4 http://www.amazon.co.uk/dp/B00F3B476O
5 http://www.amazon.co.uk/dp/B00F3B48WW

Thanks folks!

I am having trouble getting it to work in the Google spreadsheets and would prefer to do this in Excel, too.
=value(importXml(F7,ʺ//span[@id='priceblock_ourprice']ʺ)) // where f7 has the URL (It was working last year with =value(importXml(F7,ʺ//b[@class='priceLarge']ʺ)))

The XML for the price also has class="a-size-medium a-color-price"