On sheet 1 of my spreadsheet I have a column that needs to be populated with a number that corresponds with a country.
At present users have to find the country they are inputting from a list on sheet 2, column A, and the corresponding number in sheet 2, column B. They then need to go back to sheet 1 and input the correct number. Is there a way in which users could type in the country in sheet 1, and using a formula, excel automatically changes it to the associated number in sheet 2? I do use Vlookup but was under the impression this could only be done once the spreadsheet was final and not in anticipation of data being entered.
I hope this makes sense!
Thanks
Bookmarks