Advertisement
Guest User

Untitled

a guest
Oct 8th, 2015
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. =iferror(if(len(G5)<=22, expand(Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", G5), "table", 1),(MATCH(G5, (Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", encode(G5)), "table", 1),0,1)), 0)),3)), expand(Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", (CONCAT(Left(G5, 22), "..."))), "table", 1),(MATCH(CONCAT((Left(G5, 22)), "..."), (Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", CONCAT((Left(G5, 22)), "...")), "table", 1),0,1)), 0)),3))), if(len(G5)<=22, Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", G5), "table", 1),(MATCH(G5, (Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", encode(G5)), "table", 1),0,1)), 0)),3), Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", (CONCAT(Left(G5, 22), "..."))), "table", 1),(MATCH(CONCAT((Left(G5, 22)), "..."), (Index(ImportHtml(CONCAT("http://services.runescape.com/m=itemdb_rs/a=12/results.ws?query=", CONCAT((Left(G5, 22)), "...")), "table", 1),0,1)), 0)),3)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement