Hello,

I am working on a worksheet with 3 columns. A with dates, B with invoice
numbers, C with names.

I'd like to put a function in cell D1 that looks up a specific date in
column A and a specific invoice in column B and returns the name in column C.
Note that although there are several identical entries in columns A and B,
there is only one matching combination. (Although it would be a good idea to
get an error warning if there are 2 or more matching combinations).

Also is there a way (copy-paste or other) to get only unique entries from a
column (that is to exclude repeated entries)?

Any help apprieciated,

Thank you.