Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =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