Sort:  

There is a formula in excel for a vlookup but it can also be done on vba programming.

What is a vlookup?