#NAME? Error with Excel 2013

Hello Excel Forum community,

I'm experiencing a difficulty within Excel 2014, it's really bothering me and I'd like your help on fixing this.

I made a spreadsheet for a game called EVE Online which allows me to view current market prices and with that calculate my profit made per item. I don't think I have to go into details on this, because it's all pretty obvious. The thing is, I made it on Google Docs and it works there. When I tried to import it so that I could use it with Excel 2014 (to remove the limited amount of XML imports) it gave me the #NAME? Error.

The Google Doc version is here:
https://docs.google.com/spreadsheet/...rive_web#gid=0

I use the command "=ImportXML(CONCATENATE(Sell_Swap,TypeID&JOIN(TypeID,$C3:$C26)), "//sell/min")" to calculate the sell price (and the buy price is the exact same, instead "//buy/max" at the end.

When I try the EXACT same thing in Excel 2014, it spits out the #NAME? error.

Is there anyone that can help me with this issue?

Yours sincerely,

Floris.


EDIT:

Thank you for all your replies and input. I have now added the workbook to this post. (Named "Market").
If you look at the bottom of the excel sheet at the "Ferox" line, you see a simpler version of the formula that I was trying to accomplish. The formula at the bottom correctly retrieves the information I need.
The formula at the top doesn't do what I want, and I can't understand what.

What the top formula should be able to do is as follows:

Depending on what the current swap group is (Jita Sell/Amarr Sell/Dodixie Sell/Rens sell) it should retrieve different information that you can see in the "Math" tab.
It should put together the TypeID with the url (that you can see in the bottom formula). I hope I've made this clear enough.

Anyone that can solve this riddle?

There is no ImportXML function in Excel. You may be able to use FilterXML...

There is no JOIN worksheetfunction, either.

I can't access your Google Docs spreadsheet, it needs a login.

And what is Excel 2014?

How about you put it into Excel and attach it, rather than Google docs (which I still can't access without logging in, and I won't...)
then make clear what you're trying to achieve...

Please upload your sample workbook to the forum. many members are unable (or unwilling) to download files from file-hosting sites.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

JOIN(TypeID,$C3:$C26) creates an array of whatever is in those cells with what's in named range typeID as a delimiter
so say

=JOIN(TypeID,$C1:$C3) and typeid referred to a named cell eg D1
put an x in D1 and martin 1,martin 2,martin 3
in $C1:$C3 the output would be

martin 1xmartin 2xmartin 3
to replicate that in excel you would have to concatenate all the cells individually
ie
=C1&D1&C2&D1&C3&D1

have you tried replicating the join bit as instructed?
have you tried it without using concatenate or join and just typed the whole thing out manually to see if it works at all?

=ImportXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=24692", "//sell/min") works in goggle docs
its what the =ImportXML(CONCATENATE(Sell_Swap,TypeID&JOIN(TypeID,$C3)), "//sell/min") generates
does it work with FilterXML in excel?
if if does youll have to create your string with excel functions only

haven't got 2013 i dont think the functionality exists import xml and the way it works looks to be specific to google docs
maybe it can be done with code. ill ask elswhere dont forget not everything that works in google docs works in excel and vica versa and often has to be written as a udf in excel .

Will C3 be:
=FILTERXML(WEBSERVICE(CONCATENATE(Sell_Swap,TypeID,B3)),"//sell/min")

ha never heard of webservice()!

I think you must use Ctrl+Alt+f9 or perhaps you may add +NOW()*0 and then only use f9 to recalculate.

You are welcome. Thank you also.