I have a couple of worksheets. The 1st has drop down menus made up of the items from the 2nd sheet. On that 2nd sheet, each of those items has been assigned a value.
I would to be able to select an item from the drop down menu and have the corresponding value be input in a different cell.
What would be the function or macro to best accomplish this?
I would to be able to select an item from the drop down menu and have the corresponding value be input in a different cell.
What would be the function or macro to best accomplish this?