• 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


  • 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)


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


Last edited by a moderator:


Active Member
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))


Last edited: