Cell Number Formatting of Currency Based on Cell Value

[JohnTravolski]

Suppose I have the following:

Bitcoin	฿ 0.00009035​
Ether	Ξ 0.20000000​
Bitcoin	฿ 0.00040000​
Ether	Ξ 0.00600000​
Ether	Ξ 0.01300000​

I can use the following number formatting to insert the corresponding cryptocurrency symbol (Ξ for Ether, for example):

What I want is for the currency symbol to be automatically determined by the value in the left cell. In other words, if I changed the cell value from "Ether" to "Bitcoin," I would expect the currency symbol to change from Ξ to ฿. Is this possible? If so, how do you do it?

 

[Sufiyan97]

If you are open to use helper column,

Remember results are in text format so you can't use SUM for it

Book2
	A	B	C	D	E	F	G	H	I	J	K	L
1	Bitcoin	฿ 0.00009035	0.00009035	฿ 0.00009035					Currency	Currency code	Currency symbol
2	Ether	Ξ 0.20000000	0.20000000	Ξ 0.20000000					Bulgarian lev	BGN	лв
3	Bitcoin	฿ 0.00040000	0.00040000	฿ 0.00040000					Swiss franc	CHF	CHF
4	Ether	Ξ 0.00600000	0.00600000	Ξ 0.00600000					Czech koruna	CZK	Kč
5	Ether			Ξ					Danish krone	DKK	kr
6	Dollar		1	$ 1					Euro	EUR	€
7									Dollar	USD	$
8									Pounds sterling	GBP	£
9									Croatian Kuna	HRK	kn
10									Georgian lari	GEL	₾
11									Hungarian forint	HUF	ft
12									Norwegian krone	NOK	kr
13									Polish zloty	PLN	zł
14									Russian ruble	RUB	₽
15									Romanian leu	RON	lei
16									Swedish krona	SEK	kr
17									Turkish lira	TRY	₺
18									Ukrainian hryvna	UAH	₴
19									Emirati dirham	AED	د.إ
20									Israeli shekel	ILS	₪
21									Kenyan shilling	KES	Ksh
22									Moroccan dirham	MAD	.د.م
23									Nigerian naira	NGN	₦
24									South african rand**	ZAR	R
25									Bitcoin		฿
26									Ether	Ξ	Ξ
27
28
29
30
31
32
33
34
35
Sheet1

Cell Formulas
Range	Formula
D1:D6	D1	=VLOOKUP(A1,$I$1:$K$26,3,0)&" "&C1

 

[footoo]

Try Conditional Formatting.
Select B1
Formula : =A1="Bitcoin"
Set the number format.
Do the same for Ether.
Copy B1 and paste format down as far as you need.