Need Help EXCEL 2007 INDEX MATCH function:

[eskelies]

Hello, I have an array of data which has duplicates that exist in this data range. My current formula only looks at the cell below the lookup value. How can I change the following formula to search the entire array and return a "yes" or "NO?"

=IF(INDEX(C:C,MATCH(C3,C:C,0),0)<>C4,"YES","NO")

Any assistance would be greatly appreciated.

 

[MrKowz]

Is this numerical data or text data?

 

[Aladin Akyurek]

Hello, I have an array of data which has duplicates that exist in this data range. My current formula only looks at the cell below the lookup value. How can I change the following formula to search the entire array and return a "yes" or "NO?"

=IF(INDEX(C:C,MATCH(C3,C:C,0),0)<>C4,"YES","NO")

Any assistance would be greatly appreciated.

What are you trying to do?

Note that C3 and C4 are all part of C:C, so the results are necessarily YES...

 

[eskelies]

Is this numerical data or text data?

Text

 

[eskelies]

What are you trying to do?

Note that C3 and C4 are all part of C:C, so the results are necessarily YES...

look through C:C for either a single name and return yes or a duplicated name and only return the first match as yes and the rest no.

 

[GK039]

Try

=IF(FREQUENCY(C:C,C:C)>0,"Yes","No") array entered

George

Hello, I have an array of data which has duplicates that exist in this data range. My current formula only looks at the cell below the lookup value. How can I change the following formula to search the entire array and return a "yes" or "NO?"

=IF(INDEX(C:C,MATCH(C3,C:C,0),0)<>C4,"YES","NO")

Any assistance would be greatly appreciated.

 

[Aladin Akyurek]

look through C:C for either a single name and return yes or a duplicated name and only return the first match as yes and the rest no.

FAD
KAD
FAD
LAD
JAD
JAD
XAD

The above is in C2:C8.

What do you want to happen with it? One of the following maybe:

a) Check for E2 housing KAD for example. If E2 in C2:C8, return YES in F2, otherwise NO.

b) Check in D, whether A2 (which is FAD) is the first occurrence: If so, give YES, otherwise NO.

 

[eskelies]

FAD
KAD
FAD
LAD
JAD
JAD
XAD
The above is in C2:C8.

What do you want to happen with it? One of the following maybe:

a) Check for E2 housing KAD for example. If E2 in C2:C8, return YES in F2, otherwise NO.

b) Check in D, whether A2 (which is FAD) is the first occurrence: If so, give YES, otherwise NO.

To go a little further:

KAD YES
FAD YES
LAD YES
JAD YES
JAD NO
XAD YES
KAD NO
FAD NO

 

[barry houdini]

In D2 try this formula copied down

=IF(COUNTIF(C$2:C2,C2)=1,"YES","NO")

 

[eskelies]

Thank you Barry. This appears to have worked.

In D2 try this formula copied down

=IF(COUNTIF(C$2:C2,C2)=1,"YES","NO")