ISBLANK to multiple cell

[FauzanOmar]

Hi, how do I insert formula to capture data above?
Basically, If I write Singapore, the formula will automatically detect the USD rate 2,000, and if I write London, the formula will automatically detect the RM1,000.

I tried to enter formula ISBLANK and Index & Match to the cell range, but it doesn't detect the data.

Thanks

 

[GraH - Guido]

Maybe

=INDEX(VALUE(I4:I6&J4:J6),MATCH(E3,H4:H6,0))

 

[pecoflyer]

Another way =SUMPRODUCT(--($H$4:$H$6=$E$3)*$I$4:$J$6)

 

[bosco_yip]

Here is other formula options to get the result as same as Grah-Guido's

=SUMPRODUCT(I4:J6*(H4:H6=E3))

or,

=LOOKUP(9^9,(I4:I6&J4:J6)/(H4:H6=E3))

Regards