=SUM(N(FREQUENCY(IF(C1:C20="Yes",MATCH(A1:A20&B1:B 20&C1:C20,A1:A20&B1:B20&C1:C20,0)),MATCH(A1:A20&B1 :B20,A1:A20&B1:B20,0))0))

This is an array function, so it must be entered using Ctrl+Shift+Enter (not
just enter). Hope that works for you..

Alternatively, try this:
=SUM(N(FREQUENCY(IF(C1:C20="Yes",MATCH(A1:A20&B1:B 20&C1:C20,A1:A20&B1:B20&C1:C20,0)),MATCH(A1:A20&B1 :B20&C1:C20,A1:A20&B1:B20&C1:C20,0))0))


Regards,
Ryan---

--
RyGuy


"Jeff" wrote:

The function that I have tried to use, but does NOT work is:

=MATCH(D4,$A$4:$C$65500,FALSE)

"Matching 3 columns to 1 cell" wrote:

I have 9-digit account number in the first 3 columns (from A4:C65002) that I
am trying to verify if the number that I have in range D4:d54. I am trying
to use the match function to perform this, but apparently the match function
will NOT match between 3 columns only one column.

Is there a way to perform this function that I am trying to do??