Using Google Sheets. In one cell, I have a dropdown list that is generated from a concatenation of integer ID column and name column. To get the value of the integer from the selection, I have another cell with this formula:
=LEFT(N1, FIND(" ",N1))
Is there a way that the formula can be used inside the same cell that has the dropdown, without getting a circular dependency error?