Screenshot (4).png
I need a formula to match the date in column A with the date in column J, then multiply the corresponding FX rate in column K with the number in column G and put in the answer in column H.
For example I I want to match the date in A216 with the date in column J which is J216 and then multiply the FX rate for that date which is in cell K216 with the number in G216 and put the answer in H216.
I have been really trying to figure this out but keep getting errors. Any help would be greatly appreciated!
Bookmarks