Vlookup table array based on criteria

zarija

New member
Joined
Sep 12, 2012
Messages
3
Reaction score
0
Points
0
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
 

Attachments

  • table array based on the date.xlsx
    8.9 KB · Views: 28

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
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?
 

zarija

New member
Joined
Sep 12, 2012
Messages
3
Reaction score
0
Points
0
hi CheshireCat,

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

zarija
 

CheshireCat

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
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.
 

Attachments

  • zarija 2012-09-13.xls
    24 KB · Views: 28
Top