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

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

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

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 D4:D54. What is not clear is
what do you want to do? HTH Otto
"Matching 3 columns to 1 cell" <Matching 3 columns to 1
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??

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

"Otto Moehrbach" wrote:

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 D4:D54. What is not clear is
what do you want to do? HTH Otto
"Matching 3 columns to 1 cell" <Matching 3 columns to 1
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??

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

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