Fetch and autocomplete the data from another worksheet

So the problem is that I would like, when I start to type in one worksheet cell for excel to look at the data from a specific column in another worksheet in the same file and auto completes the information. So for example, I start to type in a column in worksheet 1 B-A-R and the excel is looking for the info from a column in worksheet 2 and offers me to or just auto completes BARCELONA. The second thing, which could be great, is that when excel auto completes BARCELONA it looks up the second column and fills information SPAIN in column besides in worksheet 1. Of course all the relevant data is in the worksheet 2. I am sorry if I confused you all