Assign value to dropdown

[mattbarb]

Hi,

I'm trying to create a dropdown that show a text value e.g. High but has a value associated to it so I can calculate it.

https://we.tl/t-GCnCPTCPcA

Thanks

Matt

 

[Fluff]

Maybe something like
=LOOKUP(A1,{"High","Low","Medium"},{100,1,50})
where A1 is the dropdown
The words in the lookup must be in alphabetical order

 

[DanteAmor]

Put the list in cells and its value on the right, eg.

Excel Workbook
	A	B	C	D	E	F	G
1	Speed (Dropdown)	Impact (Dropdown)	Effort	Total		DATA	VALUE
2	Low	Medium	5	11		Low	1
3						Medium	5
4						High	10
Sheet1

Review:
https://www.dropbox.com/s/is9r9f70iyhqaiw/dropdown dam.xlsx?dl=0

 

[mattbarb]

Thanks you!!!

 

[DanteAmor]

You're welcome. Thaks for the feedback.