# Eve Excel Addin - it can't be this complicated to get a character location?

**URL:** <https://forums.eveonline.com/t/eve-excel-addin-it-cant-be-this-complicated-to-get-a-character-location/515398>\
**Category:** EVE x Microsoft Excel Add-in\
**Created:** [July 26, 2026, 4:29am UTC](https://forums.eveonline.com/t/eve-excel-addin-it-cant-be-this-complicated-to-get-a-character-location/515398 "2026-07-26T04:29:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Croda\_UK](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/croda_uk/32/486948_2.png) [@Croda\_UK](https://forums.eveonline.com/u/Croda_UK)\
**Post date:** [July 26, 2026, 4:29am UTC](https://forums.eveonline.com/t/eve-excel-addin-it-cant-be-this-complicated-to-get-a-character-location/515398/1 "2026-07-26T04:29:49Z")

</div>

thinking about the Eve Excel Addin. Just how complicated is it to get the character location in one formula. I may be missing something?

the best i could do was:

Assume the character name is on cell D4 (which can be found using the formula EVEONLINE.CHARACTER(A4) where cell A4 is the character ID), then the formula to find a character location is:

=EVEONLINE.STATION(SUM(IFERROR(EVEONLINE.ACTIVE\_CHARACTER().location\_station\_id,0) \* (EVEONLINE.ACTIVE\_CHARACTER().name=D4.name)))

which is pretty complicated?

Has anyone managed to get a simpler formula?

And it is weird. the range of methods that can be used on the EVEONLINE.ACTIVE\_CHARACTER() formula are different to the range of methods that can be used on the EVEONLINE.CHARACTER() formula. Thats what makes it all complicated. The EVEONLINE.CHARACTER() formula does not give the option to find the station location of the character.

I put this on my blog: [marketsforISK: Eve Excel Addin Formulas: Characters connected to the Addin and Character Location](https://marketsforisk.blogspot.com/2026/07/eve-excel-addin-formulas-characters.html)

---

<div class="post-metadata">

**Author:** ![Croda\_UK](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/croda_uk/32/486948_2.png) [@Croda\_UK](https://forums.eveonline.com/u/Croda_UK)\
**Post date:** [July 26, 2026, 4:35am UTC](https://forums.eveonline.com/t/eve-excel-addin-it-cant-be-this-complicated-to-get-a-character-location/515398/2 "2026-07-26T04:35:49Z")

</div>

and, as ever, the community comes up with a solution

=(EVEONLINE.STATION(EVEONLINE.CHARACTER(character\_id,TRUE).location\_station\_id))

---

<div class="post-metadata">

**Author:** ![Sara\_Seraph](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/sara_seraph/32/495525_2.png) [@Sara\_Seraph](https://forums.eveonline.com/u/Sara_Seraph)\
**Post date:** [July 26, 2026, 2:17pm UTC](https://forums.eveonline.com/t/eve-excel-addin-it-cant-be-this-complicated-to-get-a-character-location/515398/3 "2026-07-26T14:17:23Z")

</div>

Thank you.  
That happened to be one of those initial entries I moved-on-from-to-come-back-later-too.

So of course I moved to a structure working out of Perimeter. So how to get an either or…? o?