Hi Jack

Try
=IF(AND(ISNA(MATCH(B3,F:F,0)),ISNA(MATCH(B3,G:G,0) )),"No","Matched")

--
Regards

Roger Govier


"jack" wrote in message
oups.com...
formula does not seem to work correctly. any other suggestions?

=IF(ISNA(MATCH(B3,F:F,0)),IF(ISNA(MATCH(B3,G:G,0)) ,"","matched"),"No")


thanks!


On Feb 8, 12:46 pm, "jack" wrote:
On Feb 8, 10:55 am, Toppers wrote:


In Sheet1 (assuming list1 is here) in column B and copy down:

=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),IF(ISNA(MATCH(A2, Sheet2!B:B,0)),"","Matche**d"),"Matched")

This will check entries in column A of list1 against columns A &B of
list2
(on Sheet2)and put "Matched" in B if a match is found.

HTH

"jack" wrote:
I have two lists of data that I want to compare to see if there
are
any common entries. should I do this using a vlookup or matching
function? or other?

as below, the data is formatted differently in each list- this
first
list is a combination of 7 and 10 digit codes, the second has both
the
7 and 10 digit code for each entry:

List 1
aaaaaaa
bbbbbbbbbb
cccccccccc
ddddddd
..
..
..
..

List 2
xxxxxxx xxxxxxxxxx
yyyyyyy yyyyyyyyyy
zzzzzzz zzzzzzzzzz
..
..
..
..

thanks for your help!- Hide quoted text -

- Show quoted text -

cheers, thanks!- Hide quoted text -

- Show quoted text -