Comparative Operator Displays Incorrect Results

[legalhustler]

I think I'm over thinking this....nonetheless let us continue......

I am trying to compare cells B2:B12 with E3:E6. However it's not displaying the results that I want.

=$B$17:$B$27=$E$3:$E$6 and when I evaluate it (pressing F9 key), it displays:

{TRUE;TRUE;FALSE;FALSE;#N/A;#N/A;#N/A;#N/A;#N/A;#N/A;#N/A}

I would like for it display: {TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;FALSE}. How can I make this happen?

Cells B2:B12 contains:

101000
101000
101000
101000
101000
610000
610000
298500
298500
298500
SGL Not Found

Cells E3:E6 contains:

101000
101000
298500
610000

 

[shobolos]

=isnumber(lookup(b2:b12,e3:e6,e3:e6))

 

[XOR LX]

Hi.

ISNUMBER(MATCH($B$17:$B$27,$E$3:$E$6,0))

Regards

 

[legalhustler]

Hi.

ISNUMBER(MATCH($B$17:$B$27,$E$3:$E$6,0))

Regards

Thanks! The mega formula I'm working on is pushing my limits.

 

[XOR LX]

You're welcome!