Hello people, i need some suggestions/ideas on overcoming the following problem:

Lets say I have typed "abc" and 123 in cells A1 and B1 respectively. Next, i defined a Name (from the Insert option) called "abc" with the reference of B1. In other words, if i were to type =abc in any cell, it would give me the value 123.

Now, if i were to just type =A1, excel would just return "abc" instead of my desired value of 123. I understand that by equating =A1, excel would just copy anything directly from cell A1.

So is there a way to solve this problem? I do not want to directly put =abc in a cell, instead i would prefer putting =to_any_cell which will have the defined name and would give me the desired output (which is the value 123 in this case). This is because i would like to create a drop-down list in a cell which will hold these defined names.

Thanks in advance.

Regards.