-2

I have an excel sheet which fetches the values from an API and these values changes in real time, I mean the row position changes on daily basis. Problem is when I reference a particular row to write a formula in another sheet and its value changes tomorrow I get the wrong value because it is a cell-based reference and not a value based. How to handle such scenario?

Sandesh shetty
  • 1
  • 1
  • 3
  • 1
    Please add a specific example. – sancho.s ReinstateMonicaCellio Feb 12 '18 at 10:42
  • This question is impossible to answer as written. The solution might involve named ranges but that is just a guess. If you actually gave details, it might be possible to do something better than guessing. Please read [ask] and [mcve] – John Coleman Feb 12 '18 at 10:57
  • Hello sancho,I am using this API to get the data to excel using web "https://api.coinmarketcap.com/v1/ticker/?limit=0" This gives a set of 1000+ rows and it changes the row positions all the time based on the market condition. – Sandesh shetty Feb 13 '18 at 04:45

1 Answers1

0

Excel has several worksheet functions for that purpose. The most popular is VLOOKUP, where you know the column in which your value resides but not the row - precisely what you seem to explain. Google for "Excel VLOOKUP" or simply look in Excel's own Help.

Variatus
  • 14,293
  • 2
  • 14
  • 30