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
Bookmarks