If cells have the same data

[mcgrath1980]

Hi

I have a massive sheet full of data , I only want to read the data when the numbers in row B match the numbers in row E.

Is there a lookup I could put into row G that could show me the duplicate numbers ?


Thanks

 

[njimack]

=if(b2=e2,...

 

[Special-K99]

The columns in B and E are independent of each other?
You just want to find if the value in B1 exists in column E and not on the same row?

Bs missing in column E
in G1
=IF(ISNA(MATCH(B1,E$1:E$10000,0)),"Missing","")

E's missing in column B
in H1
=IF(ISNA(MATCH(E1,B$1:B$10000,0)),"Missing","")

 

[mcgrath1980]

I have tried this : =IF(B3=$D$1:$D$101,yes) But the message shows as FALSE , When I now it should be YES

 

[njimack]

Maybe this:
=IF(COUNTIF($D$1:$D$101,B3),"Yes","No")

 

[mcgrath1980]

That's exactly what I was looking for thanks very much.

 

[Special-K99]

=IF(B3=$D$1:$D$101,"yes","no")

is an array formula

Array formula, use Ctrl-Shift-Enter