Fast Typing With Keywords

I'm working on an Excel spreadsheet and basicly i'm inserting manually data from a lot of paper forms.

It isn't a dificult thing, but is boring, because I have to do more than 2000 forms per week!
I want to accelerate, and how to do that

Problem: "Address"! The Excel page that i'm working has a column to feel with Addresses manually, but I have a table with all correct Address names from the city that I'm working about in other page.

What I would like is when start typing some keyword from the Address cell, it could show me all the choises of input (based on the correct Address Table)

Excel, by default, show, by exact order, all the choises, already typed on the same collumn.
I don't want that.

- imagine I have the Table 1 (representing the table with all city adresses) with a collumn called 'Address' with:

A1 - Street ZXY
A2 - Avenue QWE
A3 - Street QWE
A4 - Avenue ZXY

when typing on another Table, if I write something like “QWE” show me the A2 and A3 to choose wich I'm going to feel, and the same to “ZXY”, showing the A1 and A4. Other thing, if I write “QWE street” may show A3 also. Keyword is what i'm talking about