Ajwilltravel
New member
- Joined
- May 2, 2017
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- MS Office Prof Plus 2013
Hi there
In the attached file I need to input formulas in cells T10:T11 and U10:U11. The formulas in there currently are not working. So in T10 for example, if cell I10 = AUD then I need to lookup the table of rates in cell range Z1:AY5 for the relevant Period AND year (in cells D10 and G10) and multiply the value in cell K10 by the corresponding rate in the table in Z1:AY5 - 1st row of rates. In the row below the currency is GBP so I also need to include GBP in the formula (3rd line of rates in the table). I also need to include USD - much simpler as if I10 (and so on) = USD then I just have to pick up the value in L10 (the USD value).
This was working as an IF statement combined with HLOOKUP for 1st financial year but now that the data is crossing 2 financial years it is no longer working (as I have multiple criteria for the HLOOKUP - both the year and the period no.
I hope all this makes sense!
Thanks
Andrea.
In the attached file I need to input formulas in cells T10:T11 and U10:U11. The formulas in there currently are not working. So in T10 for example, if cell I10 = AUD then I need to lookup the table of rates in cell range Z1:AY5 for the relevant Period AND year (in cells D10 and G10) and multiply the value in cell K10 by the corresponding rate in the table in Z1:AY5 - 1st row of rates. In the row below the currency is GBP so I also need to include GBP in the formula (3rd line of rates in the table). I also need to include USD - much simpler as if I10 (and so on) = USD then I just have to pick up the value in L10 (the USD value).
This was working as an IF statement combined with HLOOKUP for 1st financial year but now that the data is crossing 2 financial years it is no longer working (as I have multiple criteria for the HLOOKUP - both the year and the period no.
I hope all this makes sense!
Thanks
Andrea.