Index and match – need to try this from Lifehacker.

http://lifehacker.com/seven-useful-microsoft-excel-features-you-may-not-be-us-1753221566

Seven Useful Microsoft Excel Features You May Not Be Using