Hi,
I need some help with is problem. I have 2 worksheets. The first worksheet
has 2 columns called "Security ID" and "Security Name" in column A and B. The
second worksheet also has 2 columns with the same heading but in column E and
F.

I like to compare each row in column E and F in the second worksheet against
all in column A and B in the first worksheet. If it found something both are
identical (both the ID and Name), then put a "y" in column G in the second
worksheet. Otherwise, put "n".

All elements in columns mentioned above are in text format.
This is an example of how one worksheet looked like:

Security ID Security Name
NC123456 NORTEL INVESTMENT
DD123456 JAMES BOND INVESTMENT

Thanks a bunch.