Comparing 2 columns of data

Topic

New Reply

Rows a1-a143, I have a master list of contract numbers. In rows g149-g179 I have another list of other contract numbers, some that may or may not be on the master list. What I would like to do in h149-h179 is return a “Not Found” message if the contract number in the corresponding cell in column g is not found in the master list at a1-a143. Any help? I have seen it before utilizing the “Match” function, but couldn’t locate it.
Thanks in advance.

Reply | Quote

Replies

In H149 enter this: =MATCH(G149,A$1:A$143, )

cheers, Paul

Reply | Quote

building on Paul’s post:

in H149, enter: =IF(ISERROR(MATCH(F8,$A$1:$A$3,)),”not found”,”found”)

and fill down to h179.

Of course, you can change the messages in the IF test.

Fred

Reply | Quote

Thanks guys.

Reply | Quote