find matching values in two lists (xl2kspsomething

Topic

New Reply

Brain addled, again.
The file has two lists (which will eventually become dynamic named ranges.)
What formula in column B produces the results shown for the presence (or not) of each value in list1 in list2?
Thanks in advance!

Reply | Quote

Replies

without the unwanted error concerning the value 433 **grin**

Reply | Quote

In cell B2:

=COUNTIF($E$2:$E$6,A2)>0

and fill down as far as needed. Replace $E$2:$E$6 with the name of the dynamic range when you’ve created it.

Reply | Quote

Of course!
Thanks, Hans, and maybe the response time is a record?
I was worrying my weary head about logical rather than counting formulas….
Thanks again!

Reply | Quote