Hi
Can anyone tell me how I can give something from a drop down list a certain value.
Like associating Apple with the value 1
Banana with the value 2.
So that when you chose "Banana" from the drop down list, a cell returns the value 2.
Hi
Can anyone tell me how I can give something from a drop down list a certain value.
Like associating Apple with the value 1
Banana with the value 2.
So that when you chose "Banana" from the drop down list, a cell returns the value 2.
Check out Vlookup
https://www.contextures.com/xlFunctions02.html
You can also use the Index Formula
https://support.office.com/en-us/art...2-b56b061328bd
Last edited by jomaor1; 04-23-2019 at 04:04 PM.
John.
"I excel at jumping to conclusions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks