Lookup value when certain condition met

Hi All,
I am trying work out formula to use which will return the last value in a particular ROW, if a particular condition is met.
So say, in Column B we have currency type: GBP/USD/EUR etc. If I want to lookup the last value in a particular row which is associated with a specific currency what is the best way to go about i?
I can manage to lookup final value in a specific row using '=OFFSET('Old Mutual International'!$D$16,0,(COUNT('Old Mutual International'!$D$16:$W$16)-COUNTIF('Old Mutual International'!$D$16:$W$16,0))-1)' But is there a way to return this same value if a particular currency is listed in column B?
Thanks in advance!

Hello ELJIWA,

This forum section is for VBA solutions. What you seem to be referring to is an in-cell solution. If you would like a VBA solution just reply in the affirmative and i'll try to write something up, if you want to keep using in-cell methods you can look into index-match formulas.

Best Luck,

DarkF1ame