franathive
New Member
- Joined
- Mar 8, 2018
- Messages
- 4
Hi,
I have the following situation. I am trying to look up months and currency conversion rates. I have a table which I am maintaining that looks like this.
<tbody>
</tbody>
On a different tab, I have a list of invoices.
It looks like this:
<tbody>
</tbody>
There must be an easier way than if/then and < and > symbols. These formulas are getting long.
Basically, I have lookup currency on chart, if invoice date is greater than x and less than y, then z. But it is getting cumbersome. Am I missing something easy?
I have the following situation. I am trying to look up months and currency conversion rates. I have a table which I am maintaining that looks like this.
1/1/2018 | 2/1/2018 | 3/1/2018 | 4/1/2018 | 5/1/2018 | etc | |
GBP | 1.2 | 1.3 | 1.4 | 1.5 | 1.6 | |
EUR | 1.2 | 1.25 | 1.26 | 1.27 | 1.28 | |
USD | 1 | 1 | 1 | 1 | 1 |
<tbody>
</tbody>
On a different tab, I have a list of invoices.
It looks like this:
Customer NAME Customer A | INVOICE DATE 1/15/2018 | Current drop down GBP | I want this column to be a formula driven 1.2 |
Customer B | 3/15/2018 | EUR | 1.26 |
Customer C | 2/5/2018 | USD | 1 |
Customer D | 1/17/2018 | GBP | 1.2 |
<tbody>
</tbody>
There must be an easier way than if/then and < and > symbols. These formulas are getting long.
Basically, I have lookup currency on chart, if invoice date is greater than x and less than y, then z. But it is getting cumbersome. Am I missing something easy?