Gotta run so il make this short. I am still learning some of the formatting for spreadsheets so im sorry if this is a nooby question

Here is my current formula

=ImportXML("https://api.eveonline.com/char/charactersheet.xml.aspx?vcode="&API!B5&"&keyid="&API!B4&"&characterid="&Basilisk!B4&"","eveapi/result/rowset//row[@typeid=3306]/@level")

This takes my API key that is stored on other pages, and finds the current level of the type ID of 3306, which is Medium energy Turret. What i want this to do is reference a cell for the type id instead of typing it in. I guessed and tried

rowset//row[typeid="&B1&"]/@level")
rowset//row[typeid="B1"]/@level")
rowset//row[typeid=&B1&]/@level")

I was thinking that i might have to do a "join" thing, i am not that familiar with it yet. If it indeed this, could somebody give me a hand?

=ImportXML("http://api.eve-central.com/api/marketstat?&v="&JOIN(",",$D5:$D159); "/sell/min")

something like that :)

the d column would be full of all the item ids only, but at the moment eve central is not working and hasnt bene fo rhte last 24 hrs solid :(,

yopu can use http://api.eve-marketdata.com and get the formula from hter ebut the market data is a day old so not really good for uptodate manufacturing costs :(, also steves eve-central google docs script works ace but is only region wide prices so if lookign for a specific station/system it wont work, aparantly you can pull the same data of crest or you can get uptodate market info of it aswel but u need to get a auth crest thingy wich i havent a clue what to do there sorry :( trying to work that one out at the mo myself

You may not be able to reference other cells in that particular part of the ImportXML function. One thing you might try is have 2 columns for your skill data. The first pulls a list of typeids and the second a list of levels, then do a VLOOKUP for each typeid/level you wish to use