• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF that = that AND that = that return that (Solved)

Taryn

New Member
I need to rebase the Banking Value (Col J) using the FX rate relevant to the Banking Currency (Col G) and the month (Col A)
The first instance of the currency should be fine as I need the Forecast Rate anyway.
Your help will be greatly appreciated
 

Attachments

  • Chandoo Template.xlsx
    163 KB · Views: 3
Last edited by a moderator:
i have answered but at excelforum
i seem to have linked to wrong question

i thought i saw and answered the same question at excelforum, i look it up and report back

oh well, having a senior moment or its been closed by admin or somehting

anyway here is a solution which may help

=INDEX(FX!$E$4:$P$273,MATCH(Sheet1!$G7&"forecast Rate",FX!$A$4:$A$273&FX!$C$4:$C$273,0),MATCH(Sheet1!$A7,FX!$E$2:$P$2,0))
 

Attachments

  • Chandoo Template-ETAF (2).xlsx
    165.2 KB · Views: 2
Last edited:
Back
Top