sorry for the vague title but I'm not sure how exactly to describe this.
I've created a spreadsheet and used the Coinmarketcap API to pull lots of data, here's the relevant part:
From another sheet I want to be able to search this pull values based on the 2nd column across (J). So for example, if I have a value of 'BTC' in my sheet I want it to search through this list and pull out the values from column AG in that row.
I've tried a VLOOKUP like so:
With B10 being the value 'BTC' but it only ever gets the value from the 'Binance Coin' (BNB) row. 25 is correctly pulling the 'AG' column at least. I've just tested manually writing "BTC" or "DOT" into the start of the VLOOKUP formula and I'm having the same problem: