Comparing two lists to find missing fields or duplicates

[styleworx]

Hi,
i have a two list of say phone types which i want to merge into 1 list. in 2003 is there any formula i can use to highlight phone types that appear in the two lists?

 

[Aladin Akyurek]

Hi,
i have a two list of say phone types which i want to merge into 1 list. in 2003 is there any formula i can use to highlight phone types that appear in the two lists?

=ISNUMBER(MATCH(A2,B:B,0))+0

would yield a 1 for everey item that exists in column A (list 1) in column B (list 2), 0 otherwise.