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
Rodrigo_'s avatar
Rodrigo_
Iron Contributor
Dec 09, 2022

EllenKristina 

Based on your explanation, you could use INDEX and MATCH functions
also there is a VLOOKUP and XLOOKUP functions.

I'm not an expert but I can help you with my knowledge, if you want, you can share your file here so I can have better understanding on what you're looking for.

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