Data imported changes cell

I have imported data from coinmarketcap, its fine and dundee, live and refreshes every 60s. My problem is that the table isnt neat at all and has lots of data that i just dont need. I then pushed the whole thing down the bottom of the file, and created a new table cleaner, easier to read, with only the information(coin prices) I need on it, and put in the cells the formula to just mirror the ones on the live table down the page eg (=E150) or something. The problem is that some of the data changes up and down the ranking from 1 to 100 on the live table, and since the cell formula is to copy an exact cell, then when that changes, the values become value from incorrect cells… does anyone know how to fix this ??

Using VLOOKUP() function should help to solve your question.
VLOOKUP help

thank you very much, all sorted. :wink: