Forum Discussion

EllenKristina's avatar
EllenKristina
Copper Contributor
Dec 09, 2022

Lookup with more than one criteria

Hi,  I have an Excel sheet with several transactions in different currencies and on different dates. In the next sheet I have an overview of all the different currencies on each day for a given peri...
excel
Formulas and Functions
EllenKristina's avatar
EllenKristina
Copper Contributor
Dec 10, 2022

Rodrigo_ 

 

Thank you so much,

 

An example of this case is attached. Long story short - i need to know the rate to each purchase.  

 

Edit: I was not able to upload the file for some reason...

 

 

 

 

Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 10, 2022

Hi EllenKristina 

 

So nobody waste time: which version of Excel do you run?

  • EllenKristina's avatar
    EllenKristina
    Copper Contributor
    Dec 10, 2022

    Hi Lorenzo 

     

    I'm on Version 2210 (Build 15726.20202)

Resources