Add dropdown in the sheet and select data as the source of drop down and select value based on the selection and position you will get the value that's it.