Lookup Horizontal and Vertical Date and FX Rates

[askall1000]

Hi,

Would you please help me with the following need:

I want to retrieve FX rate from "list of FX" according to currency type and date to highlighted yellow column. Apologies for not proper excel data. At work it is not possible to use XL2BB. Thank you very much for your help in advance.

 

[Sanjeev1976]

Hi,

Try using the below formula in M4

=INDEX($E$7:$G$12,MATCH(J14,$D$7:$D$12,0),MATCH(K14,$E$6:$G$6,0))

 

[askall1000]

Hi,

Try using the below formula in M4

=INDEX($E$7:$G$12,MATCH(J14,$D$7:$D$12,0),MATCH(K14,$E$6:$G$6,0))

Thank you very much for your help, it does the job. Have a nice day sir.

 

[Sanjeev1976]

Great and thanks for your feedback