After some assistance on importing data to excel


(Volnax) #1

So I’m basically attempting to make a spreadsheet that will allow me to see the average item price for select items

I have used fuzwork to convert item names to id’s and can import raw market data from
https://esi.tech.ccp.is/latest/markets/prices/

what I’m unsure of is how to use them together to match the item name with the id and the value I’m after for the average price in excel

what i want to do is display the data on a separate sheet as ItemName & averagePrice in a table
using the itemName to match that price from its id in the market data

any ideas


(Blacksmoke16) #2

https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 is what you would want. Use it to lookup the name/price of an item given a name/id from a list of items.


(system) #3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.