Creating a Vlookup formule with two search criteria

Hello everyone, I'm glad I found this website ! It's been really helpful for my work.

I am trying to create a "vlookup" formula with two criteria but I don't know how to write it. I have two separate tables: The first one contains three columns: the name of the country, monthly consumer price index (CPI) since 2010, date of the corresponding CPI (in the format mmm-yy). The second one also contains three columns: Country name, country iso (in two letters), date of last indexation for that country (in mmm-yy format)

So in the first table, there are many times the same country name because there are many different dates (the CPI statement is available for all months)

My goal is to create a column in the second table, displaying the CPI corresponding to the country name AND the date of the last indexing (in the mmm-yy format). I guess I need to create a Vlookup formula that looks for a match for the country name and the date in the first table ?

Thank you very much in advance.

Thomas.

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

Thank you. When I try your formula, I got a "#SPILL!" error on the cell. Any idea why ?

I also had to replace all the "," with ";" to make it work, but I think it's because of the 2016 suite.

Thanks again,

Thomas

If AR and 3-Feb does not exist in Feuil1, it returns smaller closest date 2-Feb:

=LOOKUP(2,1/(Feuil1!$A$2:$A$87=A2)/(Feuil1!$B$2:$B$87<=B2),Feuil1!$C$2:$C$87)