How to populate the column 3 under this condition??

[raghuprabhu]

Hi All,

I have a small problem.

In sheet2 of the attached file, I have in column1 have group, column2 has items, column3 also has the same items, some of them missing.

When I select an item in the form from the dropdown list, I want the comment to be populated as shown. If the item selected from column2 is from group1 and is not in column3 then I want the comments column to be as shown.

I need some help to achieve this.

Thanks

Raghu Prabhu

[kvsrinivasamurthy]

In C2 then drag down.

Please Login or Register  to view this content.

[kvsrinivasamurthy]

post deleted