tlc53
Active Member
- Joined
- Jul 26, 2018
- Messages
- 399
Hi there,
I would like my drop down list to contain a detailed description of what the user is entering, but only return the numerical value.
On Sheet1, I would like dropdown list to appear in Cells F7-F99.
On Sheet2, I have my dropdown list information;
Column A Column B
1 0 0 - STD
2 1 1 - Receivable
3 8 8 - Exempt
4 9 9 - N/A
I would like the dropdown list description to show column B, but return what is in column A.
Can anyone help please?
Thanks!
I would like my drop down list to contain a detailed description of what the user is entering, but only return the numerical value.
On Sheet1, I would like dropdown list to appear in Cells F7-F99.
On Sheet2, I have my dropdown list information;
Column A Column B
1 0 0 - STD
2 1 1 - Receivable
3 8 8 - Exempt
4 9 9 - N/A
I would like the dropdown list description to show column B, but return what is in column A.
Can anyone help please?
Thanks!