Hello,

I haven't touched code in 10+ years and I need to do this
quick thing and... errr... could someone just flesh it out
a bit for me and I'll do the rest of the legwork? Maybe
just some help with the syntax and looping statements? It
would be much appreciated.

I have two LONG single-column lists, each one on it's own
spreadsheet tab. There are product categories with
indented product listings under each category. The
categories all start with the same 6 characters (say
ABCDEF) and then a bunch more characters. Starting at the
top of one worksheet, I want to go down 1 item at a time
and see if it's in the 2nd list. If it ISN'T, I want to
color that entry or flag it in some way.

ABCDEF-53426334
bat
cat
dog
mouse
ABCDEF-827726363
armadillo
cat
ferret

Everything's in alphanumeric order -- categories and
products -- and the categories are unique and won't
repeat, but the products might. The test has to be
correct for the given category, so 'cat' has to be tested
twice in the case above, and match-tested within the same
category on the other sheet.

Anyway, any and all help would be appreciated. Even
guidance to an article or link to a similar exercise.

Thanks in advance!
Glenn