Problem with data validation

[anandvh]

Hi,

I am trying to find a solution for the following problem:

I have a list with two columns in sheet2. The first column if the item id and second column is the item description.

Sheet1 contains a form for user entry. A user can enter 10 items in this sheet in rows 3 to 12. The user has to enter the item id in Column B. In each row, I want to show the item description in column B which I did using data validation. However the problem is that once a user selected the item description, I want the cell contents to show the corresponding item id in place of the item description.

Is there a solution using either a formula or vba code that will acheive this ?

Any help will be greatly appreciated.

Thanks in advance for your efforts.

Anand