dimanche 4 juillet 2021

Google sheets If vlookup formula

Im building a financial dashboard and import table data from stockanalysis.com. I have noticed that i will need to convert reports from CNY to USD eg.Alibaba

Im using vlookup to pull specific data i want into a seperate sheet and a dashboard to summerise that data. The highlighted revenue when converted to USD should be 110812.4498

enter image description here

this is my attempt at converting but failing.

Any help is appricated

=if(VLOOKUP(B3,'Income Statement QoQ'!$A$5:$AW$45,3,0)Dashboard!A2 = "CNY",C3*GOOGLEFINANCE("CURRENCY:CNYUSD"))

Aucun commentaire:

Enregistrer un commentaire