I have a file with a list of names in one column and a number that is assigned to that name in a second column.
Is there a way that I can create another sheet where if that number is entered it will replace that number with the name?
For example 'John' is assigned 1234 on Sheet 1, if I enter 1234 on Sheet 2 I would like it to display 'John' instead.
Bookmarks