I need to retrieve a dropdown actual value, i.e. the text rather than the index.

So, based on MS instructions as in https://support.office.com/en-in/article/Add-a-list-box-or-combo-box-to-a-worksheet-5ef0fee8-2a1e-43b2-bfea-67cf48fef130

*Use this number in a formula to return the actual item from the input range.*

*For example, a dessert preference form has a list box that is linked to cell C1, the input range for the list is D1:D5, and the items in the range are: "Ice Cream" (D1), "Cake" (D2), "Liqueur" (D3), "Candy"
(D4), and "Chocolate" (D5). The following formula, entered in cell B1, returns the value "Liqueur" from range D1:D5 if the value of C1 is 3, based on the current selection in the list box.*

I'm using "INDEX" function.

It should work, but i get the following message.

The one difference is that my dropdown Formula links to another sheet, so my it is like

DropDown Input range : SomeSheet!$B$3:$B$112

DropDown Cell link : $D$36

Retrieval Cell Formula :

=INDEX(SomeSheet!$B$3:$B$112,D36)

So, I ask : WHAT IN THE WORLD IS THAT, fellows?

Thanks in advance!