What formula should be used?

[fishcakes]

I am trying to create a formula that will achieve the following...

If cell B5 is populated with CAD, then Cell A9 will be populated with the information in Cell B4 (1234)
or
If cell B5 is populated with USD, then Cell B9 will be populated with the information in Cell B4 (1234).

So something likes, if CAD is selected in B5....

If USD is selected in B5....

 

[rlv01]

Something like this?

Book1
	A	B
1
2
3
4	Data Code:	1234
5	CAD or USD	USD
6
7
8	Code (CAD)	Code (USD)
9		1234
Sheet1

Cell Formulas
Range	Formula
A9	A9	=IF(B5="CAD",B4,"")
B9	B9	=IF(B5="USD",B4,"")

Cells with Data Validation
Cell	Allow	Criteria
B5	List	CAD,USD

 

[fishcakes]

Excellent, thank you

rlv01​