How to populate the column 3 under this condition??

[raghuprabhu]

Hi Alan,

There is a form included in the attached workbook.

The source list for the combo box is column 2 in sheet2

when I select an item in the combo box for input in sheet1, if the item is not in column 3 of sheet2, say if I select "ItemG16", then I want it to input "ItmeG16" in column 2 and in column 3 input the comment "Instead of ItemG16 use ItemG11"

Alan Thanks for your input

Kind regards

Raghu

PS How do I attach the file the second time?