Before I start, let me say I haven't found n answer so far. I probably used the wrong search string. The question is simple and I hope the solution will be too, as I am not an experienced coder. I have a table with two columns. The first one contains country names (e.g. Greece), the second the associated country code (e.g. CX045). I would like to type the country name in one cell, press enter and see the country code appear in the cell nearby. Is there any function to browse the table and get the code I want when the input text matches?
Thanks for any piece of advice.