Populating Cell Only If Multiple Criteria Matches

[mcarcharocles]

Hello, Everyone.

I am puzzled with what formula(s) to use to obtain the following:

I have two worksheets. The first contains a list of software (some having duplicate listings) in column A and a list of comments in column B. None of the software titles that have duplicates will have comments.

The second worksheet contains a condensed list of software (the previous list without the duplicates) and a column for the comments.

I need to have a formula that populates the second worksheet comments cells with the corresponding comments from worksheet one only if:

(1) The software title in worksheet two matches the software title in worksheet one
(2) The comment cell in worksheet one contains a comment (or text)

I have had only partial success; my obstacle being the duplicate software titles in worksheet one.

I have attached a snapshot as an example.

Rod

[NBVC]

No attachment...please try again