extracting information from a URL

This is not a beginner excel application -- this is a pretty advanced use, actually, because you're trying to automate a bunch of external web connections, and you'll probably need some kind of way to process and clean input, and manage output, and there's a lot of room for error handling too?

Not really sure what you mean by handeling inputs and outputs. I've already created some formulas to change the inputs into a google . com link. And what i ment I suppose was that i'm a beginner trying to create this sheet. What I'm looking for is how to find the correct matrix etc in the browser, to tell the lookup formula where to look.

I suppose it should look something like this =LOOKUP(9E+300,--LEFT(REPLACE(A1,1,SEARCH("cid=",A1)+3,""),ROW($A$1:$A$20))), only with different cells, names and numbers.

EDIT:
Or i suppose it would be easier with some kind of API and use webservice and filterxml?

Good morning KasperChr

Originally Posted by KasperChr

EDIT:
Or i suppose it would be easier with some kind of API and use webservice and filterxml?

With that comment in mind, have you looked at Forum Guru Kyle123's solution here : https://www.excelforum.com/tips-and-...ml#post2678041

HTH

DominicB

Hi KasperChr

To mark the thread as solved just go to Thread Tools (right at the top) and click on "Mark this thread as solved".
Don't worry about it this time though - I've done it for you.

DominicB