Match 3 columns to one cell

[Matching 3 columns to 1 cell]

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??

 

[Jim Cone]

Try CountIf
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Matching 3 columns to 1 cell" <Matching 3 columns to 1
(e-mail address removed)>
wrote in message
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??

 

[Otto Moehrbach]

Your statement:
"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. "
isn't clear. I understand that you have 9-digit numbers in Columns A:C. I
gather that you have some numbers in the range D454. What is not clear is
what do you want to do? HTH Otto
"Matching 3 columns to 1 cell" <Matching 3 columns to 1
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Jeff]

To see if any numbers in columns A to C match any of the data that I have in
column D

 

[Jeff]

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

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

 

[ryguy7272]

=SUM(N(FREQUENCY(IF(C1:C20="Yes",MATCH(A1:A20&B1:B20&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:B20&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---