=IF(B1=C1,"",IF(VLOOKUP(B1,$B$1:$C$4,2,FALSE)=B1,"",B1))

Where the key list is in column "B" and the partial list is in "C", both lists are contained in Range: $B$1:$C$4

Note: change to your range.

"2" is column "C" the second column in your range, as if the range you indicate is the whole sheet, "C" on a normal sheet is column "3" but in your two column range "B&C" "C" is the second column.

"False" to only search for an identical match, "True" would be to find and match the closest item.

If the value in column "B" is found in cloumn "C" put a blank in the column that contains the formula, if the value in column "B" is not found in column "C" then list the value from column "B" not found in column "C."

The First part of the formula above will filter to see if Row values "B&C" match if they do match skip the search. This step speeds the code up. Just copy the formula down any column starting in the row that list "B" starts in and adjust the search range to match your two column list. JSW

_________________<INPUT type="JSW" value=" Excel On... Coder's!" ID=Text1><spanstyle='font-size:36.0pt;color:#FFCC00'>JSW<o

></o

></span>[/b]</p><spanstyle='font-size:36.0pt;color:#FFCC00'>Try and try again, " The way of the coder!"<o

></o

></span>[/b]

This message was edited by Joe Was on 2002-08-30 22:00