EVE Technology Lab

Hello,

I am trying to put together a google spreadsheet that automaticly going to get the price from eve-central.

In Column A I have item name
In Column B I have item id

And now where the problem begin.

I have in column C this forumula

=importxml("http://api.eve-central.com/api/marketstat?typeid=4405&usesystem=30000142","/evec_api/marketstat/type/sell/min")

This formula is working fine as long as I give the typeid manually

But If I change the typid with this ?typeid=B1 it give me an error.

I don t want to manually change the formula each time with the item id, I want a formula that automaticly going to replace the itemID with the cell in column B.

Is this possible ?

Thanks