Forum Discussion
Look Up FX Rate by Transaction date
Hello Folks, Attached you will find a sample file where I am trying to do the following: https://docs.google.com/spreadsheets/d/1NeCSt8oAcEM86DAxI-8LkqTQK4D6WQvv/edit?usp=sharing&ouid=1033547533...
As variant
=C2/IF(B2="C", XLOOKUP(A2,'FX Rate'!$A$2:$A$8,'FX Rate'!$B$2:$B$8,,-1), 1)if you use first of each month in FX rate