# Comparative Operator Displays Incorrect Results

#### legalhustler

##### Well-known Member
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

Cells E3:E6 contains:

101000
101000
298500
610000

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
=isnumber(lookup(b2:b12,e3:e6,e3:e6))

Hi.

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

Regards

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.

You're welcome!

Replies
2
Views
315
Replies
26
Views
1K
Replies
3
Views
1K
Replies
5
Views
2K
Replies
5
Views
2K

1,196,360
Messages
6,014,814
Members
441,847
Latest member
hw407

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back