These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Join Group IDs (google sheets)
Author
Previous Topic Next Topic
YoHoBro
Doomheim
#1 - 2015-05-31 06:18:12 UTC
I am trying to write a function that would retrieve several groupIDs. For example, I want to retrieve the name of the following shield mods: Shield Extender, Shield Recharger, Shield Booster, Shield Transporter. Their Group IDs are 38, 39, 40, 41, respectively.

I was thinking of using the query, but I seem to get an error when retreiving more than one of them. Here is my function when only taking one:

if(Item_dropdown="Shields",query(TypeID!A:B,"select B where A=38",1)

Thanks for the help.