Register
Results 1 to 3 of 3
  1. #1
    gavreel's Avatar
    Posts
    72
    Reputation
    1
    Tagged in
    18 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
    aprilmyriad's Avatar
    Posts
    309
    Reputation
    24
    Tagged in
    96 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
    gavreel's Avatar
    Posts
    72
    Reputation
    1
    Tagged in
    18 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, 02:26 PM
  2. Quick question about item values on the AH
    By Valmount in forum Archive (General)
    Replies: 12
    Last Post: January 6th, 2014, 07:37 PM
  3. A question about Item tracker
    By iit76 in forum General TradeSkillMaster Discussion
    Replies: 1
    Last Post: July 15th, 2013, 09:20 PM
  4. Basic Toon/Spec Guides?
    By Faid in forum Archive (Powerleveling)
    Replies: 4
    Last Post: October 30th, 2011, 11:38 AM