CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Anshul Gautam
Anshul Gautam

Reputation: 15

Function call / Referencing from within a string

IMPORTDATA("https://min-api.cryptocompare.com/data/price?fsym=DOGE&tsyms=INR")

I have the above given function, and I have to call this function again with different parameters i.e. "DOGE" and "INR" will have to be replaced with a new set of parameters.

But I am not able to figure out how to reference cell within the url here.

Column_Reference The column which has to be iterated over looks like this.

I tried using cell reference directly, string manipulation but it didn't work as it didn't recognise it as a formula.

IMPORTDATA("https://min-api.cryptocompare.com/data/price?fsym=A2&tsyms=INR")
IMPORTDATA("https://min-api.cryptocompare.com/data/price?fsym=LEFT(A2,10)&tsyms=INR")

Upvotes: 0

Views: 174

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

Please use this formula and drag down

=IMPORTDATA("https://min-api.cryptocompare.com/data/price?fsym="&B2&"&tsyms=INR")

enter image description here

Upvotes: 1

Related Questions