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