Show data depending on value

[Bexi]

I want to automatically populate the "Rates" from another worksheet. I
tried the formula
=IF(ROW(G50)<=COUNTIF('Working Data'!K:K,F50),INDEX('Working Data'!
L:L,SMALL(IF('Working Data'!$K$6:$K$207=F50,ROW($A$6:$A
$207)),ROW(G50))),"")

but, the return value was blank. The value should have been .1465

I have this list in column F50:F54 and want the value to be retrieved
from the Working Data worksheet from column L to column G50:G54.

Country Currencies: Rates:
China .1465
Hong Kong .1288
Pound 1.5038
Euro 1.5856
US 1.0000

The Working Data worksheet may not have all these currencies. If no
rates were found, the field should be blank as I am using the Rates to
do a calculation.

Please help.
Thanks

 

[Pete_UK]

Did you commit that (array) formula using Ctrl-Shift-Enter (CSE)
rather than the usual <Enter>?

Pete

 

[Bexi]

Did you commit that (array) formula using Ctrl-Shift-Enter (CSE)
rather than the usual <Enter>?

Pete








- Show quoted text -

I did use the array (Ctrl+Shift+Enter) when I enter the formula.

Thanks