Vlookup table array based on criteria

Dear All,
can you pls help with the following problem? I have the attached simplified table, where I would like to return Comment next to an Invoice based on the date in column 3. I need the specific comment on day (they are changing over time) but invoice numbers are repeating in the list.


How can I solve this easily? I was thinking of adding another column with the invoice+date combination using concatenate function and building the vlookup formula on the invoice+date combination, but would prefer solving it in one step without adding more columns.

Thanks for the help in advance,
zarija

Hi zarija,

Your sample table includes entries for the same invoice and on the same day. Is that likely to occur in your actual data?

hi CheshireCat,

no, sorry, that should not happen. Invoices can appear more times, but only with different dates.
thanks,

zarija

Try this arrangement.

Change the invoice and/or date values in F2 and F3 to see the corresponding Comment in F4.

Note - The formula is confirmed as an array formula with Ctrl-Shift-Enter.

thank you CheshireCat!