Register now or log in to join your professional community.
i.e while typing the data it should give matching options below similar to auto fill in Google search. This is to make data entry easier by selecting options from below instead of typing it again or going up and copying the similar values.
I used INDEX/MATCH for things like this, but you can also use VLOOKUP() or LOOKUP() based on some other restrictions about the layout of the table you're searching. INDEX/MATCH has none of those restrictions
http://www.excelforum.com/excel-general/676832-match-two-cells-composed-of-text-in-the-same-row.html#3