[Solved] Perform table lookup using alias for key
Posted: Sun Sep 15, 2024 9:39 am
Hello! I have a table of my wallets where I typed coins and amount of coins. And I also count usd value with this formula:
Sheet "Wallets":
I use page Prices where I placed prices of coins like this (and I update it from time to time)
Sheet "Prices"
As you can see, coin HYP (the name of this coin on coingecko) has alias HYPRA in Xeggex. And I wish to use this name HYPRA as Xeggex uses. But I wish to use name HYP on sheet "Prices" as everybody others use. So i defined sheet "Aliases"
Sheet "Aliases":
How to improve my formula for count amount in usd using aliases on certain exchange?
I attach my file aliases.ods.
Code: Select all
=IFERROR(ROUND(C2*INDEX($Prices.$A$2:$Prices.$B$180,MATCH(B2,$Prices.$A$2:$Prices.$A$180,0),2),2),"")Code: Select all
Wallet Coin Amount USD
Xeggex BTC 0.0002 11.56
Xeggex ETH 0.01 24.2
Xeggex HYPRA 45000
Xeggex SOL 20 2740
TradeOgre HYPRA 12000 I use page Prices where I placed prices of coins like this (and I update it from time to time)
Sheet "Prices"
Code: Select all
Coin Price
BTC 57800
ETH 2420
HYP 0.0017
SOL 137Sheet "Aliases":
Code: Select all
Coin Where Alias
HYP Xeggex HYPRA
HYP Tradeogre HYPRA
SMARTIE Xeggex SMTCode: Select all
=IFERROR(ROUND(C2*INDEX($Prices.$A$2:$Prices.$B$180,MATCH(B2,$Prices.$A$2:$Prices.$A$180,0),2),2),"")