Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Results 1 to 3 of 3
  1. #1
    US-Kil'Jaeden(H)
    Ethereal Contributor
    gavreel's Avatar
    Posts
    52
    Reputation
    0
    Tagged in
    13 Posts
    Add to this user's reputation

    Just a basic question about item ID's

    I am working on a transmog analysis project and need to convert a master list of item id # back to the item names in MSExcel is there an easy way to do this?

  2. #2
    US-Turalyon(H)
    Entrepreneur
    aprilmyriad's Avatar
    Posts
    230
    Reputation
    14
    Tagged in
    73 Posts
    Add to this user's reputation
    Download a master list of Item IDs (I use the resource page on wowuction.com). Then put the downloaded data into a worksheet in your document and use the lookup function to return the appropriate value. For example:

    =LOOKUP(cell number of item you want looked up, range of Item Ids from downloaded data, range of Item Names from downloaded data)

    http://www.techonthenet.com/excel/formulas/lookup.php for more info on Lookup syntax.

  3. #3
    US-Kil'Jaeden(H)
    Ethereal Contributor
    gavreel's Avatar
    Posts
    52
    Reputation
    0
    Tagged in
    13 Posts
    Add to this user's reputation
    Thank you most appreciated

 

 

Similar Threads

  1. GUIDE: Build a BASIC shuffler with TSM 2.0
    By Kathroman in forum Archive (Professions)
    Replies: 58
    Last Post: May 31st, 2014, 01:26 PM
  2. Quick question about item values on the AH
    By Valmount in forum Archive (General)
    Replies: 12
    Last Post: January 6th, 2014, 06:37 PM
  3. A question about Item tracker
    By iit76 in forum General TradeSkillMaster Discussion
    Replies: 1
    Last Post: July 15th, 2013, 08:20 PM
  4. Basic Toon/Spec Guides?
    By Faid in forum Archive (Powerleveling)
    Replies: 4
    Last Post: October 30th, 2011, 10:38 AM