NEED URGENT HELP!!!!!!
Would like to know how to create a dropdown combo in excel, such that should user select from the dropdown list, excel would display a corresponding value of the selected item, rather than displaying the actual selected item.
Sample Date
Code Value
101 Agriculture Loan
102 Auto Loan
Dropdown Combo source should be from column ‘Value’, but should user select say “Auto Loan”, combo should rather display “102” INSTEAD OF “Auto Loan”
Many thanks
Bookmarks