The one value that Bob is matching is a concatenation of your 3 criteria.
Instead of "abc" you would use:

"March2005John Doe" or cell references to your criteria:

D1&E1&F1 (where D1=March, E1=2005, and F1=John Doe)


" wrote:

Maybe I misunderstand the statement, but this looks to me like it is
matching 1 value in three columns. If I'm wrong, can you please explain
how it works?

Maybe too my example was abstract and not clear enough so I'll try
again. I have a sheet with several columns. I have a.o colums: month,
year, customer, no of consults etc. Now I want to find the row where
the month, year and customer match certain values in order to find how
many consults the customer made in that particular month. How do I find
the row with this particular information? How do I find efficiently the
row where year matches 2005, month matches March and customer matches
John Doe?


Kind regards
Wilco