Logic Formulas (IF,IFS etc)

[mackan7695]

Hello,

Col A Col B Col C
Row 1 USD EUR AED
Row 2 0.2724 1.2 1.00


I have three difference currency exchange rates above. I want to create a formula in column F below, that looks up the currency ISO code (in this case EUR,AED or USD) in column D below and if the ISO currency code matches with either of ISO codes in cells A1,B1 or C1, it will multiply the currency exchange rate from above matrix with the correct currency pair. I.e. => IF(Cell D3=A1,(Cell E3*Cell A2), Cell D3=B1,(Cell E3*Cell B2), Cell D3 = Cell C1, (Cell E3*Cell C2). I tried IF formula and IFS, coupled with OR, but can't get it right. Can anyone help? Thanks in advance!

Col D Col E Col F
Row 3 EUR 100 X
Row 4 EUR 100 X
Row 5 AED 200 Y
Row 6 USD 300 Z

/Mackan7695

[ChemistB]

You can use an HLOOKUP instead. Your original little table is in A1:C2
In F3 for example

=HLOOKUP(D3, $A$1:$C$2, 2, FALSE) * E3

If there's a chance the code might not be there, you can wrap an IFERROR around the HLOOKUP
Questions?

[newdoverman]

One way:
Enter this in F3 and fill down

Please Login or Register  to view this content.

	A	B	C	D	E	F
1	USD	EUR	AED
2	0.2724	1.2	1
3				EUR	100	120
4				EUR	100	120
5				AED	200	200
6				USD	300	81.72