Idex match or vlookup in combination of concatenate date cells with text?

[EvoBob]

Hi,

Here is an example of my excel file:
Excel example.xlsx

I have a problem regarding multiple search values which consist of date and text and duplicates.

I would like to get information (right bid/ask for the right currency pair at the right time) from sheet 2 into sheet 1. So i need to find the matching date and pair (for instance bid DEM/CHF 1/26/1997 17:49:24) from sheet 2 and bring it into sheet 1.

In sheet 1 I have a time table for every second which means that if there is no observation matching in sheet 2 I will use the last bid/ask quote for the respective currency pair.



I have tried index match formula and vlookup by concatenate the date cells with the pair without success.

Does anyone have a good tip for how I can get the information into sheet 1?

This is just an small example, my sheet 2 has 250K rows with around 8 currency pairs in total.


Thank you so much for your time and help!

Let me know if you need some more information.

And sorry for my english, im native norwegian