Need assitance on complex formulae

[Sameer_Kanade8810]

Hi All,
I am trying to perform a matching activity but with a criteria please suggest how can i achieve this.

file 1 Data 

ID 1              | Price | Date | CCY | SYSTEM PRICE DATE
9A0AAAF                                        09/30/2024


file 2 Data 

DATA        Price   |    Date          |      CCY  |
9A0AAAF     10      10/30/2024         USD
            

Now i need to populate data in File 1 just like the vlookup and get the price date and CCY in blank row of file 1. But the criteria is First it should match date if the system date is much latest than file 2date it should drop the values.
If the file 2 date is greater than system should take information from file 2 data and paste it to file 1. Data which needs to be updated are Price date CCY

[binuacs]

@Sameer_Kanade8810 use join tool to connect both your files using the join key as ID1 and DATA fields, then use a filter tool to apply the condition you mentioned

[Raj]

@Sameer_Kanade8810 
upload a sample input file and expected output file as the data pasted is not so clear to understand
will be in better position to help.