I have a formula:
IF(COUNTIF(A2:C6,A1)

The problem is that i need to search in two areas. The above formula only search the whole area without breaking an area.

For example to what I want:

A1 4 6 8 9 10
A2 5 6 23 44 50
A3 4 7 8 9 22
A4 7 3 1 2 8

I want to search row A2 and A4 only to see if any number matches with any number in A1.

Thank you very much!!!!

EggHeadCafe - Software Developer Portal of Choice
Generic GetXmlReader Data Access Method
http://www.eggheadcafe.com/tutorials...ader-data.aspx

IF(COUNTIF(A2:C6,A1)
I want to search row A2 and A4

A2 and A4 are not rows, they're individual cells.

Based on the above formula maybe this is what you want:

=COUNTIF(A2:C2,A1)+COUNTIF(A4:C4,A1)

--
Biff
Microsoft Excel MVP


<sierra spiegel wrote in message
...
I have a formula:
IF(COUNTIF(A2:C6,A1)

The problem is that i need to search in two areas. The above formula only
search the whole area without breaking an area.

For example to what I want:

A1 4 6 8 9 10
A2 5 6 23 44 50
A3 4 7 8 9 22
A4 7 3 1 2 8

I want to search row A2 and A4 only to see if any number matches with any
number in A1.

Thank you very much!!!!

EggHeadCafe - Software Developer Portal of Choice
Generic GetXmlReader Data Access Method
http://www.eggheadcafe.com/tutorials...ader-data.aspx