Hi,

Take a look at VLOOKUP here

http://www.contextures.com/xlFunctions02.html