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.
Bookmarks