Im learning how this all works… Ive read this guide and with success might I add, I got the application made and verified.
https://developers.eveonline.com/blog/article/using-esi-with-google-sheets
Scroll down to Getting Your Character Assets … I copied the guide as is, and in a1 entered the following
=characters_character_assets()
and I get back some data, just like in the flash video shown in the guide. Only in mine, the columns are arranged different. Which leads me to why I am here. I tried to do the last steps on this guide,
=HLOOKUP(“name”, universe_types_type(“en-us”, INDIRECT(ADDRESS(ROW(), 1)), True), 2, FALSE)
and
=HLOOKUP(“description”, universe_types_type(“en-us”, INDIRECT(ADDRESS(ROW(), 1)), True), 2, FALSE)
but I get an error
Error
HLOOKUP evaluates to an out of bounds range.
Is this because my columns are different? I didnt edit anything differently from the guide. I used the guide to copy text from, and pasted into the sheets. I used the same cells as well.
Thanks for any help provided. cheers.