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
Bookmarks