defined name problem

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.

Hi

Can you please review the forum rules regarding the post titles and then edit your post and change your title. Perhaps something like "indirectly reference a defined name".

Try

Please Login or Register  to view this content.

rylo